| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get Excel date to change from 1/1/1900?
I am entering the date (8/25/2005) in a cell that is date-formatted.
However, once entered the cell always displays 1/1/1900 (Excel's embedded calendar start date), i.e. it doesn't display the date I entered. How do I get it to display teh date I entered? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Threaded Mode
