View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacky Jacky is offline
external usenet poster
 
Posts: 20
Default Automatic adding in a single cell w/o equal sign

Thank you John, also very helpful and good to know.

"John" wrote:

Hi Jacky
Maybe this will help if I understand your question.
If you use a lot your numeric keypad for your calculations, start with a + on
the keypad instead of the = sign, e.g. +5+5-5, +5*5.etc. The + sign is handy
right beside your numbers.
You should know that in the future, Microsoft will stop using that function and
you will need to use the = sign.
Its a backward compatibility with Lotus123 and is no longer used.

HTH
John

"jacky" wrote in message
...
I want to be able to add several numbers in each cell w/o equal sign.

5+5+6 and have the total come up when i press enter on the keyboard.
thanks

"Gary''s Student" wrote:

Tell me about the cells. Are they in some column or row ??
--
Gary''s Student - gsnu200842


"jacky" wrote:

Thank you for the information Gary, however; I need to do this in several
cells where i am able to add in the individual cell. Can you help

"jacky" wrote:

how do I automatically in a single cell input 5+5 without the equal sign
and
have a total come up