This is exactly what I need! But when I do it, the correct date displays up
in the toolbar, but in the cell it is not correct. For instance for
20030105, in the cell I get 38355. Am I missing something?? Thank you for
all your input.

"Peo Sjoblom" wrote:

Datatext to columns, click next twice and under column data format select
date and YMD
then click finish.


--

Regards,

Peo Sjoblom


"Sandyw" wrote in message
...
I have a date entered as 20050103. How do I get it to change to 1/3/05?