ledzepe

if the text is in cell A9

=DATE(LEFT(A9,4),MID(A9,5,2),RIGHT(A9,2))

Regards

Trevor


"ledzepe" wrote in
message ...

Hi everyone,

In our system generated .CSV file, one column is the date in the format
of YYYYMMDD, for example 20060301.

I want to format this column to this date format, 3/1/2006, but I
can't. It just gives me a bunch of #'s. I copied the column to another
sheet but got the same result.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile:
http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=517978