| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date format in Excel 2003
When I am entering date as 08/20/2007, the return is "01/01/1900."
Previous cells in my workbook are fine, it is just the new ones come in this way. First I chose date, format, then 3/14/01 and the result is the same "01/01/1900" Next I went to custom and chose mm/dd/yyyy;;; with the same result. How do I get the correct format?? Thanks, Steve T. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - Changing Date Format | Excel Discussion (Misc queries) | |||
| Cant get dd/mm date format in Excel 2003 | Excel Discussion (Misc queries) | |||
| Where can I change the footer &[Date] format in Excel 2003? | Setting up and Configuration of Excel | |||
| date format in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 date format bug? | Excel Discussion (Misc queries) | |||
Threaded Mode
