Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
I always have Excel running and it's also my calculator. I never use use a
calculator anymore! The answer to your question is no. The equal sign tells Excel that you're entering a formula that needs to be calculated. You can use a plus sign (+) instead of the equal sign (=) if you always use the numeric keypad. It's more ergonomic than "reaching" for the equal sign. Excel will accept the plus sign and upon hitting ENTER, will automatically change it to an equal sign. +44+66 [Enter] Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
See reply in .Functions
Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
No way to turn that off.
Type in the = sign. Same like starting your car..........need to insert key and turn to start. Gord Dibben MS Excel MVP On Tue, 1 Aug 2006 22:40:10 -0400, "auto" <[email protected] wrote: I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#5
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
thanks, I did not realise it convert the + to an =.
Was it always like that, even in the older excel versions? "Biff" wrote in message ... I always have Excel running and it's also my calculator. I never use use a calculator anymore! The answer to your question is no. The equal sign tells Excel that you're entering a formula that needs to be calculated. You can use a plus sign (+) instead of the equal sign (=) if you always use the numeric keypad. It's more ergonomic than "reaching" for the equal sign. Excel will accept the plus sign and upon hitting ENTER, will automatically change it to an equal sign. +44+66 [Enter] Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#6
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
no sure what you mean by that?
See reply in .Functions Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#7
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
Was it always like that, even in the older excel versions?
I'm not sure how far back it goes. Biff "auto" <[email protected] wrote in message ... thanks, I did not realise it convert the + to an =. Was it always like that, even in the older excel versions? "Biff" wrote in message ... I always have Excel running and it's also my calculator. I never use use a calculator anymore! The answer to your question is no. The equal sign tells Excel that you're entering a formula that needs to be calculated. You can use a plus sign (+) instead of the equal sign (=) if you always use the numeric keypad. It's more ergonomic than "reaching" for the equal sign. Excel will accept the plus sign and upon hitting ENTER, will automatically change it to an equal sign. +44+66 [Enter] Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#8
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
no sure what you mean by that?
Your message was also posted to the Worksheet.Functions forum where there are also replies. Biff "auto" <[email protected] wrote in message ... no sure what you mean by that? See reply in .Functions Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
#9
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Calculator always requires an = before a math function, can be turned off setting?
i c, tx
"Biff" wrote in message ... no sure what you mean by that? Your message was also posted to the Worksheet.Functions forum where there are also replies. Biff "auto" <[email protected] wrote in message ... no sure what you mean by that? See reply in .Functions Biff "auto" <[email protected] wrote in message ... I often use excel as a fancy calculator. But often I forget to start the calculator with the = sign. So if I want to add 44 + 66, I forget to type in an = sign first, an it gives me an error message. Is there a setting to turn that off, so I can type in 44 + 66 and it gives me an answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equation behind the Function | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Sheet default setting. | Excel Discussion (Misc queries) | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |