How to Format Fractions to Percentages in Excel

Save

Fractions can easily be entered into Microsoft Excel. If you want to change a fraction into a percentage, then you just need to use a simple multiplication, as you would if working out the answer with a calculator or mentally. When you type the fraction in with this method, it will automatically create the percentage of that fraction.

Using a Formula

  • Open Microsoft Excel.

  • Select a cell that contains a fraction in it, or type a fraction into a cell (proceded by a "0 ").

  • Type "=X/Y100" (without quotes). Replace "X" with the first number in your fraction and "Y" with the second part of your fraction. For example, to show a half (1/2) in Excel, type "=1/2100" and press "Enter." This will change the value to "50%" which is the percentage equivalent of that fraction. Click "OK."

Using Excel Formatting Tool

  • Open Microsoft Excel

  • Select a cell that contains a fraction in it, or type a fraction into a cell (proceded by a "0 ").

  • Right-click the cell, click "Format," and then click "Percentage" in the window that appears. Click "OK."

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!