Hi,
I need to convert the Values in a column into Date Format.
Here some cells are having multiple date values, separated by line feed.
Please see the sample attachment.
Thanks inadvance.Date Format.xls
Hi,
I need to convert the Values in a column into Date Format.
Here some cells are having multiple date values, separated by line feed.
Please see the sample attachment.
Thanks inadvance.Date Format.xls
This macro will do it. Just highlight the cells you want to convert, then run the macro, it will only affect the highlighted cells.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks the Code is very useful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks