| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date changes to formula when entered in a cell
I'm using Excel 2002. When I type a date, it changes the cell to the
formula and it changes what I typed to something else. Example: I type "8/25/2006" without the quotes. I hit enter and it changes to "=8/25/2006" in the forumla bar. But the cell displays "1/0/1900". I'm sure there is a setting causing this. Can someone help me? Thanks, Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula returns blank in the cell where it is entered | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Threaded Mode
