formula bar

P

Peter R.

I'm calculating simple percentages. I enter 5/10*100 and 50 appears in the
cell. When I go back to that cell, what shows up in the formula bar is
..5*100. This makes it impossible for me to check to make sure I entered the
correct numbers to begin with. Is there a way to make it keep the original
formula in the formula bar when you return to the cell?
 
B

Bryan Hessey

Peter,

If the cell is formatted for Percentage then enter =5/10 (equals fiv
divide by 10) to produce 50% in the cell and =5/10 in the formula bar.

The formula you are using suggests the cell is formatted to Number, bu
if you enter =5/10*100 (equal five divide by ten times one-hundred) yo
should still see 50 in the cell and =5/10*100 in the formula bar.
 
Top