The date does not show up as entered. Date format. [Closed]

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: 2718
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 15, 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.
The email address you entered is not associated with a facebook account. please enter an email address associated with the disab - How-To - Facebook
How to enter @ in computer - How-To - Internet
Entering power save mode ✓ - Forum - Windows
You have tried entering too many codes. try again later. ✓ - Forum - Facebook
No signal entering the power saving mode shortly ✓ - Forum - Monitor

1 reply

Ask a question

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

Answer 1 / 1

TrowaD

Posts: 2718
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 15, 2021

459
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. [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!