Re: $$Excel-Macros$$ Need help to convert date formate

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 vilaschav...@gmail.com wrote: Hi vinod, You are not sending me any attachment please send solve attachment please regards Vilas On Sat, Aug

Re: $$Excel-Macros$$ Need help to convert date formate

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, _

Re: $$Excel-Macros$$ Need help to convert date formate

Oops Missed to attach the file... Now done... On Sun, Aug 29, 2010 at 12:56 AM, Vinod N nvino...@gmail.com 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

Re: $$Excel-Macros$$ Need help to convert date formate

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 nvino...@gmail.com wrote: Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from