show decimal value in formula bar for cells with % format

[frustratedjohn]

How do I keep the formula bar from showing a value in decimal form (e.g., 0.50) after I have formatted the cell to be a percentage? When I change the format to %, the number in the formula bar also changes to "50%". I want the cell to display 50% but not in the formula bar (keep it as 0.50). This change doesn't happen if I format a cell to currency form - the cell will show $0.50 but in the formula bar it will still show as 0.5 (without the dollar sign).

Thank you.

 

[OaklandJim]

Hey John. I don't think that you can do what you want.