# Percentage is Showing as Thousand in Excel – Reason and Solution

## Why Is Excel Showing Wrong Percentages?

The dataset showcases percentage values.

Change the format of those cells into percentages.

Percentages are shown in thousands. The existing values are multiplied by 100.

• Change the format of all cells to Percentage.

• Enter data in different cells.

10 was entered in C5 and 1 in C10. Values changed.

Read More: Why Are My Percentages Wrong in Excel?

### Solution 1 – Enter Decimal Values and Apply the Percentage Format

This is the solution to the 1st problem.

Steps:

• Enter values in decimal format in the Profit Percentage column.

• Change the format in Number.
• Choose Percentage.
• Click Increase Decimal to unhide the lost decimal points.

The percentage value is displayed.

### Solution 2 – Divide the Percentage Value by 100

Steps:

Percentage is showing in thousands.

• Add a new column on the right.

Cells are formatted in percentage with decimal places.

• Go to D5 and use the formula.
`=C5/100`

• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

## Related Articles

<<Go Back to Calculating Percentages in Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF