Select the range of cells to be converted
Use Data | Text to Columns
Use Delimits, click Next until you get to step 3
Set Date box to YMD and press finish
Done!

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Crauwf" wrote in message
...
I have the following date 20081128

How do I convert this figure to the date 28/11/2008?

Can anyone help?

Thanks.