# How to apply the percentage number format without decimal places in Excel

Converting a number or decimal or fraction is very easy to do with Microsoft Excel. Technically Excel will convert any input data into a percentage by multiplying it by 100 & a

Converting a number or decimal or fraction is very easy to do with Microsoft Excel. Technically Excel will convert any input data into a percentage by multiplying it by 100 & adding a percentage symbol on the right if you opt to choose percentage formatting. But you can also convert a number directly to a percentage value without letting it be multiplied by 100 in Excel. Here are some useful & basic methods Ive tried to illustrate how you can do them both.

**Table of Contents** hideDownload Practice Worksheet3 Suitable Methods to Convert Number to Percentage in Excel1. Converting Decimal to Percentage with Number Format Commands2. Using Custom Format Option to Convert Number to Percentage in Excel3. Converting a Resultant Fraction or Number to Percentage in ExcelConclusionFurther Readings

**Download Practice Worksheet**

You can download the worksheet here to practice which weve used to prepare this article.**Convert Number to Percentage.xlsx**

**3 Suitable Methods to Convert Number to Percentage in Excel**

**1. Converting Decimal to Percentage with Number Format Commands**

Suppose, a business company has decided to determine the **Profit Percentage** for 12 months in a particular year. They have calculated the amount of profits subject to cost prices which are displayed as decimals in **Column B**. Now they want to convert these data into percentages.

**Steps:**

Select all cells containing the decimals and numbers in **Column B.**

Under the **Home** tab, click on **% (Percent Style)** from the **Number** group of commands.

Youve just converted all decimals into percentages right away as shown in the picture below.

**2. Using Custom Format Option to Convert Number to Percentage in Excel**

Now lets assume, the company has already calculated its percentage values & now they just want to add Percentage symbols beside all values without changing the data.

**Step 1:**

Like the previous method, select all the cells containing the percentage values first.

Under the** Home** tab & from the **Number** group of commands, click on **Number Format.**

A new tab box named **Format Cells** will appear.

**Step 2:**

Select **Custom** formatting from the** Number** tab.

Now you have to customize your format by typing in place of **General** inside the **Type **box.

**Step 3:**

Type **0\%** & Press** OK.**

Youll get all the values in percentage format at once.

**Step 4:**

If you want to add decimal places then again open **Format Cells.**

Now replace **0\%** with **0.00\%** if you want to add 2 decimal places.

Click **OK **or press **Enter** & youre done.

Now youve got all the percentage values with 2 decimal places.

**3. Converting a Resultant Fraction or Number to Percentage in Excel**

Now we have a datasheet containing the cost prices & selling prices over a year for a business company and we have to find the percentage profits by converting calculated profit values into percentages.

**Step 1:**

Select **Cell D2.**

Under the **Home** tab, choose **Percentage** format from the drop-down in the **Number **group of commands.

In** Cell D2**, type **=(C2-B2)/B2** & press **Enter**

Youve just calculated the profit percentage for January.

**Step 2:**

Now in **Cell D2**, point your mouse cursor onto the right bottom corner & youll find a **+ **icon there which is known as **Fill Handle.**

Select the **Fill Handle**icon & drag it to **Cell D13.**

**Step 3:**

Release the mouse button & the whole percentage profits for all months in the specific year will be shown right away.

**Conclusion**

So, these are the most common & effective methods you can use anytime while working with your Excel datasheet to calculate percentage values or convert any type of number into a percentage. If you got any questions, suggestions, or feedback related to this article you can comment below. You can also have a look at our other useful articles on Excel functions & formulas on this website.

## Further Readings

**Convert Percentage to Basis Points in Excel (Basis Point Calculation)****How to Calculate Discount Percentage Formula in Excel****How to Calculate Growth Percentage Formula in Excel****Excel Formula to Add Percentage Markup [with Calculator]****Excel formula to calculate the percentage of grand total (4 Easy Ways)****Calculate Excel percentage difference between two numbers (using formula)****Percentage Difference Between Two Percentages Excel (2 Easy Ways)****How to Calculate Grade Percentage in Excel (2 Easy Ways)****Subtract a Percentage in Excel (Easy Way)**