Dec 03 2018 09:53 AM
When I type in a cell, number format being "Number", a formula =500/22, the result in the cell is what I typed. If I type +500/22, the result is 22.727272. I want the cell to show the 500/22, but entering the = sign before the formula is not as easy/efficient as the key pad does not use the = sign. Any suggestions? This worksheet I use is an old worksheet that I keep updating.
Dec 03 2018 11:57 AM
Dec 03 2018 02:06 PM
Will you type =500/22 or +500/22 the result shown within the cell will be exactly the same, 22.72727.
Another story if your cell is formatted as "Number", in formula bar you see =500/22 and 22.72727 accordingly.
However, if you format (before typing your numbers) it as "General" in both cases in formula bar it will be shown =500/22. If you format after on Number the formula bar keeps =500/22