I am using MS Excel 2007 Part of Microsoft Office Home and Student 2007. When I format a cell to display the date (no matter which format of date I select) it does not return the correct date format.
Example: I format it to display 3/14/2001. I enter 73011. It should return 7/30/2011. It returns 11/22/2099.
The locale (location) selected is English (United States).
If i type it in using the /'s it comes out as expected. But I don't want to type the /'s
what else can i do to make it format properly?