General discussion

Locked

Format Dates in Excel

By ramoncarter ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Format Dates in Excel

by kees.valkenswaard In reply to Format Dates in Excel

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

Collapse -

Format Dates in Excel

by kees.valkenswaard In reply to Format Dates in Excel

? should be -
Nice all those compatible character sets.

Collapse -

Format Dates in Excel

by DKlippert In reply to Format Dates in Excel

You can use the Worksheet_Change event procedure.
See Chip Pearson's answer:

www.cpearson.com/excel/DateTimeEntry.htm

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums