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

Closed
Mymunchkins2 - Updated on May 15, 2017 at 11:29 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 11, 2017 at 10:54 AM
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
0