Re: Excel Date conversions

Giganews Newsgroups
Subject: Re: Excel Date conversions
Posted by:  Dave Peterson (ec357…@msn.com)
Date: Thu, 09 Oct 2003

One more:
=--TEXT(A1,"00\/00\/0000")
but with the cell format as a date.

Gerri wrote:
>
> 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.

--

Dave Peterson
ec357…@msn.com

Replies

None

In response to

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