Re: Excel Date conversions

Giganews Newsgroups
Subject: Re: Excel Date conversions
Posted by:  Jim (
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:

Greeting from the Gulf Coast!
"Gerri" <gpalom…> wrote in message
> 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.



In response to

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