| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel date shows 01/00/1900!
I have a whole spreadsheet where when I type in the date i.e. 3/5/05 it then
shows 1/00/00 as the date! I have tried changing the format to the many different ways to show the date, but I can't get it to show 3/5/05! Is there something I am missing? Thank you so much for your help! Katie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| Excel 2002 date formulas problem | Excel Worksheet Functions | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| Excel Date in uppercase | Excel Worksheet Functions | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Threaded Mode
