| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel change a date into a formula?
I am trying to enter in a date, let's say 7/7/07 into a cell. Excel is then
taking this date and putting an = in front of this date. It is also replacing the 07 with just a 7. I have tried formatting the cell as a date format and the result is if 7/7/07 is keyed in, it drops the 07 for 7 and returns 01/00/00. It is still putting the = sign in front of the numbers like this is a formula. I know if you put a ' in front of the date it will not do this, but I am trying to use the date as a basis for another calculation...7/7/07-28. Can anyone help with this? It only does this on certain spreadsheets. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i change the date formula | Setting up and Configuration of Excel | |||
| I need a formula that change all date by putting in one date | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Formula to change number into date | Excel Discussion (Misc queries) | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
Threaded Mode
