|Subject:||Re: Excel Date conversions|
|Posted by:||Jim (email@example.com)|
|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…@ci.concord.ca.us> 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.
Excel Date conversions posted by Gerri on Thu, 9 Oct 2003