Thank you so much - This woked great! Would you be so kind as to explain the
formula in laymen's terms? What exactly are the 2 dashes used for after the
equal sign?
Thank you again, Karen

"T. Valko" wrote:

I don't know why it would split it into 3 cells since no delimiters were
selected.

Here's a formula method:

A1 = 20090614

B1 formula:

=--TEXT(A1,"0000\/00\/00")

Format as Date

--
Biff
Microsoft Excel MVP


"Karen" wrote in message
...
Thank you for your help. Actually I tried that before I posted this
message
and it split it into 3 columns and I want it all in one column formatted
06/14/09.
Any other suggestions?
Karen

"T. Valko" wrote:

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