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

Question

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

[Closed]

Report

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

Posts: 2818
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 18, 2021

- 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 - How-To - Excel
Can't enter facebook website ✓ - Forum - Internet/Social Networks
You have tried entering too many codes. try again later. ✓ - Forum - Facebook
The email address you entered is not associated with a facebook account. please enter an email address associated with the disab - Guide
Disk boot failure insert system disk and press enter - How-To - Hardware

1 reply

Ask a question

TrowaD · Answer 1 · 2017-05-11T10:54:18-0400

Answer 1 / 1

TrowaD

Posts: 2818
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 18, 2021

486
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

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

1 reply

Your reply

Subscribe To Our Newsletter!