Hi Vilas,
Please find below the macro recorded by me...
Sub Date_Format()
'
' Date_Format Macro
' Macro to convert date format- 8/29/2010 by Vinod
'
Columns("A:A").Select
With Selection
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited,
_
TextQualifier:=
Hi Vinod,
Thank you very much,
Vinod can you give me vba code for that issue
Regards
Vilas
On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN wrote:
> Hi vinod,
>
> You are not sending me any attachment please send solve attachment please
>
>
>
>
>
>
>
>
>
>
>
> regards
> Vilas
> On Sat, Aug 28, 201
Hi vinod,
You are not sending me any attachment please send solve attachment please
regards
Vilas
On Sat, Aug 28, 2010 at 12:26 PM, Vinod N wrote:
> Hi Vilas,
> Please select column A and use Text-to-Columns under Data menu... Next
> choose the desired date format from Format--> Cells
Oops Missed to attach the file... Now done...
On Sun, Aug 29, 2010 at 12:56 AM, Vinod N wrote:
> Hi Vilas,
>
> Please select column A and use Text-to-Columns under Data menu... Next
> choose the desired date format from Format--> Cells option.. Solved copy of
> your sample file attached...
>
Hi Vilas,
Please select column A and use Text-to-Columns under Data menu... Next
choose the desired date format from Format--> Cells option.. Solved copy of
your sample file attached...
Thanks
Vinod N
On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN wrote:
> Hi friends,
>
> Need help this is data
