MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Re-arrange a date using VB Macro


Posted by Rob A on October 05, 2001 4:54 AM

I'm using a macro to format some data and the last thing i need to do is change all the dates in one long column form 24/12/01 > 2001/12/24

so dd/mm/yy > yyyy/mm/dd

any help would be most appreciated.

Cheers


Posted by . on October 05, 2001 4:56 AM

Posted by . on October 05, 2001 4:57 AM

You should be able to get the code from the macro recorder.