On paper, you multiply this number by 100 to convert it to the percentage "50%." Excel does not recognize this conversion and simply displays "50," which can cause problems in other calculations.

Percentage Formula: Know How to Calculate Percentage in Excel along with Solved questions and examples and Download formula PDF list.

SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers.