One way:

Choose Data/Text to Columns. Click Next, Next, then select ymd from
the Date dropdown and click Finish.

In article ,
"Jason Trolian" wrote:

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?