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

Closed

Mymunchkins2 - Updated on May 15, 2017 at 11:29 AM
TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 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

The date does not show up as entered. Date format.
How to enter date format in excel - Guide
Can't enter facebook website ✓ - Forum - Internet/Social Networks
You have tried entering too many codes. try again later. ✓ - Forum - Facebook
The account that owns the email address you entered has been disabled. - Guide
Disk boot failure insert system disk and press enter - Guide

1 reply

Answer 1 / 1

TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 27, 2022

514
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

Subscribe To Our Newsletter!