Forum Discussion
LBudd13
Dec 03, 2018Copper Contributor
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...
jimfikes
Dec 03, 2018Copper Contributor
So, are you wanting that cell to show 500/22 or =500/22 ?
If you are wanting =500/22, you could precede the = sign with a space or an apostrophe and it will display as text. Another way would be to enter the formula =500/22 in another cell and then, in the cell you are focused on, you could type =formulatext( ) and enter the cell reference where you typed the formula in between the parentheses.
If you are wanting =500/22, you could precede the = sign with a space or an apostrophe and it will display as text. Another way would be to enter the formula =500/22 in another cell and then, in the cell you are focused on, you could type =formulatext( ) and enter the cell reference where you typed the formula in between the parentheses.