Software

Ask something
Discussion Locked

Format Dates in Excel

0 helpful
3 replies

by ramoncarter

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Here is my problem. I have several cells that I've formatted to be in this date format: 10/02/2003. Problem is when I type in 100203 the Cell formats to 5/5/74. Why does it not format to 10/02/2003? I know I can manually type in the date with the correct format but shouldn't Excel do this automatically? Hope someone can help.

3 replies

by kees.valkenswaard

You would have to type either 10/02/2003, 10/2/03, 10/2/3 or with ? instead of /, so e.g. 10-2-3 If you omit the last / or ? and the number behind it the current year will be added. So this year 10-2 would yield 10-02-2003.
See help, dates are stored as serial numbers, starting in 1900. So your number 100203 would result in 5-5-2174. However, with a format with 2 digits for the year you would see 5-5-74.
Good luck

This discussion is closed to new replies.