I have a spreadsheet in excel 2003 with about 100 rows in column A. I need to rearrange the date format from yyyymmdd eg 20060902 to dd/mm/yyyy.
Can someone help me with a macro to do this in bulk. I am ok to put the re-arranged dates in Column B. I can't figure it out! many thanks