software

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: www.excelforum.com/member.php...oamp;userid=25207
View this thread: www.excelforum.com/showthread...hreadid=517978ledzepe

if the text is in cell A9

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

Regards

Trevorquot;ledzepequot; gt; wrote in
message ...
gt;
gt; Hi everyone,
gt;
gt; In our system generated .CSV file, one column is the date in the format
gt; of YYYYMMDD, for example 20060301.
gt;
gt; I want to format this column to this date format, 3/1/2006, but I
gt; can't. It just gives me a bunch of #'s. I copied the column to another
gt; sheet but got the same result.
gt;
gt;
gt; --
gt; ledzepe
gt; ------------------------------------------------------------------------
gt; ledzepe's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25207
gt; View this thread: www.excelforum.com/showthread...hreadid=517978
gt;
Select the column you want to change.
Select Data-gt;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.

quot;ledzepequot; wrote:

gt;
gt; Hi everyone,
gt;
gt; In our system generated .CSV file, one column is the date in the format
gt; of YYYYMMDD, for example 20060301.
gt;
gt; I want to format this column to this date format, 3/1/2006, but I
gt; can't. It just gives me a bunch of #'s. I copied the column to another
gt; sheet but got the same result.
gt;
gt;
gt; --
gt; ledzepe
gt; ------------------------------------------------------------------------
gt; ledzepe's Profile: www.excelforum.com/member.php...oamp;userid=25207
gt; View this thread: www.excelforum.com/showthread...hreadid=517978
gt;
gt;