The date does not show up as entered. Date format.

Mymunchkins2 - May 11, 2017 at 08:50 AM - Latest reply: TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen
- May 11, 2017 at 10:54 AM
I am working with excel 2007 and the dates I enter show up completely different than the data I input.
For example: I enter 050116 (no separators) and it shows up as 3/17/37. I have tried using the text to columns tab and the format tab and nothing has changed.

Thanks in advance
See more 

1 reply

Reply to this topic
TrowaD 2348 Posts Sunday September 12, 2010Registration dateModeratorStatus April 24, 2018 Last seen - May 11, 2017 at 10:54 AM
0
Helpful
Hi Mymunchkins2,

What you are entering is not a date but a number, which is then converted to a date (1/1/1900 + 50116 days).

Why not enter as 05/01/16?

Best regards,
Trowa
Respond to TrowaD