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.
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.