date format

[Douglas leckie]

I have been provided with a file where the date in the cell is the following 20080403 (yyyymmdd). This is NOT in a date format but in a General Format.

Can anyone please let me know how to change this. I have a list of these dates from cells A2:A8500, it is possibly a lot of manual changes.

Thanks in anticipation

 

[VoG]

Select your data then Data > Text to Columns. Click Next twice to take you to the third screen. Tick Date and select YMD then click Finish.

 

[Douglas leckie]

Many thanks,

you just saved me a boring job.

Regards