edit number in cell without it changing to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top