Formula or string - calculation in a cell

  • Thread starter Thread starter John61
  • Start date Start date
J

John61

In a cell where format is set as Currency, I enter 3+5 and it gives a
string, in stead of the calculation result (8 in this example). I have to
enter the equal sign first: = 3+5, then this accept it as a formula, showing
a green triangle in upper-left corner. Is there a default setting we can
change this? So I do not need to type = on each cell entry.

Thanks.
 
The "=" sign lets Excel know you've entered a formula and it needs to
calculate that formula. That's a basic operating principle of a spreadsheet,
a way of defining what is and is not a formula. The "=" sign is the default
notation used by Excel but it will also accept a "+" sign. However, I think
you should use the Excel default "=" sign.
 
Back
Top