Select the column you want to change.
Select Data-Text to columns
Select Delimited and click next
Click next again
Select Date and choose YMD
Click Finish
All cells in that column containing a number like 20060301 should now be
changed to a date like 3/1/2006.
"ledzepe" wrote:
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