edit number in cell without it changing to text
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. |
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. |
All times are GMT +1. The time now is 06:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com