Hi Jason,

Highlight the column containing the dates, select Data | Text to Columns...,
click Next twice, then select the Date radio button and change the dropdown
to YMD. Look the Data Preview to make sure it interprets your data
correctly; if everything looks good, click Finish.

Regards,

Jake Marx
MS MVP - Excel


"Jason Trolian" wrote in message
...
I have a spreadsheet that comes with the date formated
like this (yyyymmdd - 20030910) The normal format cell
function will not change that date to (mmddyy -
09/10/2003) any way I can do this?