how to have numbers add/sub without putting = infront

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

Guest

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
 
captdewey said:
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
Click to expand...
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
 
Select from the Excel menu

Tools
Options

Then select the Transition Tab

Click the check box for Transition Forumla Entry.



R
 
Ruthki said:
Select from the Excel menu

Tools
Options

Then select the Transition Tab

Click the check box for Transition Forumla Entry.



R
Click to expand...
That's a new one for me. So many options so little time :-)


gls858
 
furthermore

if you use the lotus transition you can also use the trick
5+5<>F9<>enter
and the result in the cell will be 10
not =5+5
 
Back
Top