Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operations
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? jbn10161 at fastmail dot fm |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operations
Joseph, you can use the + sign, excel will turn it into an = sign in the
formula -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Joseph N." wrote in message ... 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? jbn10161 at fastmail dot fm |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operations
Paul B wrote:
Joseph, you can use the + sign, excel will turn it into an = sign in the formula Excellent! Thank you. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Entering arithmetic operations
Your welcome
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Joseph N." wrote in message ... Paul B wrote: Joseph, you can use the + sign, excel will turn it into an = sign in the formula Excellent! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering data on custom forms. | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) | |||
entering data using tab | Excel Discussion (Misc queries) | |||
How do you omit the apostrophe before entering '07? | Excel Discussion (Misc queries) | |||
number entering | Excel Discussion (Misc queries) |