Forum Discussion
Cell results
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 e...
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