Select the column, do data>text to columns, click next twice and under
column data format select date, from scrolldown select YMD and click finish.
There is no way excel could know that a number like 20031203 is a date as
opposed to a number just by formatting, since excel dates are days since Jan
0 1900 and a date like 12/03/03 is equal to 37958, then the number 20031203
will just return ####### if formatted as a date
--
Regards,
Peo Sjoblom
Peter said:
Need to change the date format from yyyymmdd to mm/dd/yy. Tried setting
up a custom format with no results