General discussion
May 12, 2003 at 04:28 AM
ramoncarter

Format Dates in Excel

by ramoncarter . Updated 23 years, 3 months ago

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 discussion is locked

All Comments