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 |
#2
|
|||
|
|||
I'm guessing that you entered the date in the cell like this
=3/5/05 If so, a calculation is being done. I get 1/0/1900 when I enter it that way. Try just entering it as 3/5/05 with no equal sign. "KateZito" wrote: 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 |
#3
|
|||
|
|||
Actually no. I did get my problem solved though. Thank you for your
response. The problem was that when the spreadsheet was transfered over from Lotus it assumed that it was a formula - not a date. (I will put the directions on here in case anyone else has this problem) Go to Tools/Options.../Transitions tab Uncheck the box at the very bottom (Transition formula entry) Thanks again for your response! Katie "Barb R." wrote: I'm guessing that you entered the date in the cell like this =3/5/05 If so, a calculation is being done. I get 1/0/1900 when I enter it that way. Try just entering it as 3/5/05 with no equal sign. "KateZito" wrote: 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 |
Reply |
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) |