I'm trying to format numbers in an excel column to a date format.
Posted on 2011-02-12
I have a column of numbers starting in cell A1 and ending in A29163. The all have 8 numbers in the format 19000103 The first 4 numbers are the year, the next 2 are the month and the last 2 are the day. I would like the cell to show the date format as 1900-Jan-03 Can anyone please help me automate this with a vba script to do it in one shot? Thanks