Re: Excel Date conversions

Giganews Newsgroups
Subject: Re: Excel Date conversions
Posted by:  Jim (twodays@nospamcableone.net)
Date: Thu, 9 Oct 2003

You have to either use a date format recognized by Excel or use a helper
cell/column to extract and concatenate the string to appear as a date:
=LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,4).

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Gerri" <gpalom…@ci.concord.ca.us> wrote in message
news:2672401c38e84$4a8037d0$a60128…@phx.gbl...
> How do I set up a column to automatically convert numbers
> (example - 01012003) into a date format (example -
> 01/01/2003).  I tried doing this by format, cells, date -
> then entered the number and the date came up different.

Replies

None

In response to

Excel Date conversions posted by Gerri on Thu, 9 Oct 2003