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."

Related Searches

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

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