Date Format
 

The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900.
then I input 010101 which results into 8/27/27 , for 8/27/1927. this
really baffles me, as I tried to Clear All to no avail.
thanks for your help

I'm having the same problem. 12-17-04 comes in as 03-18-33, 12-14-03 =
08-25-29. IF I enter the same date again, the same wrong date is in the
column. I have repeatedly reformatted with no success. Also checked the
help site...no help there either.
Any ideas? Someone please help ASAP

"itqueencanada" wrote:

The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900.
then I input 010101 which results into 8/27/27 , for 8/27/1927. this
really baffles me, as I tried to Clear All to no avail.
thanks for your help

You may want to read about how excel treats dates (and times, too) at Chip
Pearson's site:

http://www.cpearson.com/excel/datetime.htm

You'll see why you need to either enter the slashes (or dashes) or have
something else convert it for you (a macro or a formula).

hsrosebud wrote:

I'm having the same problem. 12-17-04 comes in as 03-18-33, 12-14-03 =
08-25-29. IF I enter the same date again, the same wrong date is in the
column. I have repeatedly reformatted with no success. Also checked the
help site...no help there either.
Any ideas? Someone please help ASAP

"itqueencanada" wrote:

The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900.
then I input 010101 which results into 8/27/27 , for 8/27/1927. this
really baffles me, as I tried to Clear All to no avail.
thanks for your help


--

Dave Peterson