View Single Post
  #2   Report Post  
gls858
 
Posts: n/a
Default

captdewey wrote:
I am trying to enter numbers without putting an equals sign infront of the
numbers. I want to add or subtratct the numbers I put in. I have some
worksheets that I can do that to and some I can't. For example, If I put in
a cell 5+5, I want it to show 10 without having to put an equals sign in
front of it. I also know if you put +5+5, you will get 10, but I am looking
for the way where you can just put 5+5 and have 10

Not sure exactly what you're trying to do but without the = sign Excel
doesn't know it's a formula. You could use 3 cells
A1 A2 A3
5 5 =A1+A2

now if you hit 5 enter 5, a3 will display 10. You will need to go to
tools options edit and set the cursor to move to the right on Enter.

HTH
gls858