Percent Sign Is Displayed in the Formula Bar

CAUSE

This behavior is by design of Microsoft Excel. This behavior is different from behavior in previous versions of Microsoft Excel.

In versions of Microsoft Excel previous to version 7.0, when you enter a value with a percent sign in a cell, or format a value with a Percentage number format, the value is displayed in decimal format in the formula bar.

Note that the behavior in versions of Microsoft Excel listed above makes it convenient to enter another value in the cell that contains the Percentage number formatting. For example, in versions of Microsoft Excel earlier than version 7.0, when you enter the value 0.41 on your worksheet, and format the cell as a percentage, the value is displayed as 41%. If you then enter the value 56 in that same cell, the value is displayed as 5600%, instead of 56% as you may have intended.