Hello, I am using Excel 2003 on Windows XP. Could some one please help me with a date conversion as follows:
In column F (F2:F65000) I currently have dates in yyyy-mm-dd format (e.g. 1970-04-27).
I need this date format to be changed to: dd mmm yy format (e.g. 27 Apr 70).
Please refer to my attached image showing examples of the date formats:
Examples of Date Formats.jpg
I can do this manually, but I have 65,000 to do.
Any assistance would be greatly appreciated,
Kind regards,
Chris![]()
Bookmarks