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 January 16, 2023 - 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

The date does not show up as entered. Date format.
Excel date format dd.mm.yyyy - Guide
Format factory - Download - Other
Whatsapp date format - Guide
Openoffice date format - Guide
Samsung format code - Guide

1 reply

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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

Similar discussions

i can't enter to my account facebook

Excel date format won't change

Change date format dd.mm.yyyy to dd/mm/yyyy

Unsupported signal. Please check device output

Similar discussions

Subscribe To Our Newsletter!