Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I recently upgraded from Office 97 to Office 2000. In a worksheet I was
previously able to hit F2 to edit a number, hit the + or - to add or subtract from the original number. The revised total would show when I hit enter. Now the number changes to text and shows as 1+1 instead of 2. |
#2
![]() |
|||
|
|||
![]()
There needs to be an equal sign preceeding the 1+1. After hitting F2, hit
the home key to put the curson on the left of the existing number value in the cell then enter "=1+" so you end up with "=1+1" (e.g.). - Will "rklremote" wrote: I recently upgraded from Office 97 to Office 2000. In a worksheet I was previously able to hit F2 to edit a number, hit the + or - to add or subtract from the original number. The revised total would show when I hit enter. Now the number changes to text and shows as 1+1 instead of 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |