Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to have numbers add/sub without putting = infront
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Select from the Excel menu Tools Options Then select the Transition Tab Click the check box for Transition Forumla Entry. R -- Ruthki ------------------------------------------------------------------------ Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503 View this thread: http://www.excelforum.com/showthread...hreadid=392254 |
#4
|
|||
|
|||
Ruthki wrote:
Select from the Excel menu Tools Options Then select the Transition Tab Click the check box for Transition Forumla Entry. R That's a new one for me. So many options so little time :-) gls858 |
#5
|
|||
|
|||
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 -- Greetings from New Zealand Bill K "gls858" wrote in message ... Ruthki wrote: Select from the Excel menu Tools Options Then select the Transition Tab Click the check box for Transition Forumla Entry. R That's a new one for me. So many options so little time :-) gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |