Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operation
Hello. I'm a 1-2-3 user who is trying to become familiar with Excel. I
have a very basic question, and would appreciate any help from experienced users. In 1-2-3, if one opens a sheet and enters "4*5" the cell will show "20". Entering "10/2" will yield "5". But in Excel, even if the cells are specifically formatted as Number, it seems to be necessary to put "=" in front, so that one has to enter "=4*5" or "=10/2". Since the equal sign is in only one place and not on the extended numeric keyboard, I have to think that there's another way to do this. So, the question is whether it is really necessary to add "=" before an arithmetic operation, or is there an alternative? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operation
It is necessary!
If you want to avoid typing it, click on the "=" sign in front of the formula field right above the column headings. Hans |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operation
Or you can type "+" before the numbers, eg +4*5 - Excel will interpret
this as being an expression and will change it to =+4*5. Hope this helps. Pete |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operation
Or you can go to toolsoptionstransition and select transition formula
entry and then type the way you used to in 123. However it will screw up date entries if entered with / as delimiters -- Regards, Peo Sjoblom Portland, Oregon "Pete" wrote in message oups.com... Or you can type "+" before the numbers, eg +4*5 - Excel will interpret this as being an expression and will change it to =+4*5. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering arithmetic operations | New Users to Excel | |||
Entering Times | Excel Discussion (Misc queries) | |||
entering data using tab | Excel Discussion (Misc queries) | |||
Too many records to complete this operation | Excel Discussion (Misc queries) | |||
How do you omit the apostrophe before entering '07? | Excel Discussion (Misc queries) |