Sometimes this will work.

Select the range of cells you want to convert
Goto the menu DataText to Columns
Click Next twice
In Step 3 of the wizard, under Column data format, select Date and YMD
Click Finish then format in the style of your choice

--
Biff
Microsoft Excel MVP


"Karen" wrote in message
...
I have a column of data and the dates are in the format of 20090614. How
can
I convert these dates so they are in the following format: 06/14/09.
ANY help would be greatly appreciated
Karen