How to Converted Decimals into Fractions in Microsoft Excel

Date:2019-8-26 Author:Cordelia

When you are processing data in Microsoft Excel, the results of calculations or the numbers you need to enter won’t always be integers. So, if you’ve got a batch of decimals in the worksheet, how can you convert them into fractions or vice versa?

There’s 2 commonly used methods:

1. Percent Style

First, select all the cells containing decimal numbers.

How to Converted Decimals into Fractions in Microsoft Excel

Find Number section in Home tab. Click the icon of Percent Style. These selected numbers will be converted into fractions immediately.

How to Converted Decimals into Fractions in Microsoft Excel

How to Converted Decimals into Fractions in Microsoft Excel

2. Format Cells

Right-click the selected cells and choose Format Cell… in the menu.

How to Converted Decimals into Fractions in Microsoft Excel

Select Percentage in NumberCategory. Hit OK to confirm the setting.

How to Converted Decimals into Fractions in Microsoft Excel

Then these decimals will be converted to fractions as well.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *