formula bar
 

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?

Peter,

If the cell is formatted for Percentage then enter =5/10 (equals five
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, but
if you enter =5/10*100 (equal five divide by ten times one-hundred) you
should still see 50 in the cell and =5/10*100 in the formula bar.



Peter R. Wrote:
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?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=396949