How to Put Percentages in Google Sheets: A Quick Guide

To put a percentage in Google Sheets, select the cell and choose Format > Number > Percent, or click the % button on the toolbar. You can then enter a value such as 15% or calculate a rate with a formula. Formatting controls how a number appears; it does not, by itself, calculate a percentage.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
The values you want to display or use in a percentage calculation, with a clear idea of what each value represents.

You do not need an add-on or a special template. If the data involves money, use the examples below as arithmetic demonstrations only; check actual terms with the lender or a qualified professional before making financial decisions.

Step-by-Step

Open the sheet and identify what percentage you need. Decide whether you want to change the display of an existing decimal, enter a known percentage, or calculate a percentage from other values. For example, 0.25 can be displayed as 25%, while 25% of a total is usually calculated by dividing the part by the whole. Keeping those tasks distinct prevents a common 100-times error. If you are working with a table, label the percentage column so it is clear whether it represents a rate, a share of a total, or a change.
Select the cell or range to format. Click one cell, or drag across a range such as D2:D20 to format several cells at once. To select a whole column, click its letter at the top. Formatting a range before entering data can make later entries easier to read. Avoid selecting unrelated cells with amounts or dates, because applying a percentage format to them will change their appearance too.
Apply the percentage number format. In the menu, choose Format > Number > Percent. You can also click the % button in the toolbar. Google Sheets displays the selected numeric values as percentages: for example, a stored value of 0.2 appears as 20%. The underlying value remains usable in calculations. If the toolbar button is not visible, use the menu path; the menu is the dependable option for a selected cell or range.
Enter a percentage in the right form. To enter fifteen percent directly, type 15% and press Enter. Sheets interprets that as 0.15 and displays 15%. Alternatively, enter 0.15 and apply the percent format to display the same result. Do not type 15 and then apply percentage formatting unless you mean 1,500%; the number 15 represents fifteen whole units, and formatting multiplies its displayed value by 100 for the percent label.
Choose how many decimal places to show. A percentage may need no decimals for a simple report, or more precision for a rate such as 12.75%. Select the cell, then use the decimal-place increase or decrease buttons on the toolbar as needed. The display can round while the stored value retains more precision. For instance, a value might appear as 13% but still contribute its more exact value to a total or later formula. Do not assume that fewer displayed decimals have changed the actual calculation.
Calculate a percentage of a total when you have the part and whole. With the part in B2 and the whole in C2, enter =B2/C2 in D2, then format D2 as Percent. If B2 is 18 and C2 is 60, the result is 0.3, displayed as 30%. The formula divides the part by the whole, which is the basic method for finding what percentage one amount is of another. Make sure the whole is in the denominator and is not zero.
Calculate a percentage change when comparing two values. With the earlier value in A2 and the later value in B2, enter =(B2-A2)/A2 in C2 and format C2 as Percent. If A2 is 80 and B2 is 100, the difference is 20, and 20 divided by 80 is 0.25, so the displayed change is 25%. A negative result indicates a decrease. The earlier value is the baseline; reversing the two cells answers a different question.
Calculate an amount using a percentage rate. With a price in A2 and a rate in B2, enter =A2*B2 in C2. If A2 is 50 and B2 contains 20% (stored as 0.2), C2 returns 10. Format B2 as Percent and C2 as currency or a regular number, depending on what the result represents. Multiplying by the rate finds the percentage amount; it does not add the amount to the original price. For a total that includes the increase, calculate that separately.
Fill the method down the column if needed. After entering a formula in the first row, select its cell and drag the small square at the lower-right corner down through the rows you need. Sheets adjusts relative references for each row. For example, a formula using B2 and C2 becomes one using B3 and C3 on the next row. Check a couple of rows to confirm that each formula refers to the intended data, then apply percentage formatting to the full result range.

The same basic percentage formatting is available in Excel, but its menus and toolbar are different. These menu paths and controls are for Google Sheets in a web browser.

Common Mistakes

Formatting 15 as a percentage and expecting 15%. Sheets displays 15 as 1,500% because the number 15 is equivalent to 1,500 hundredths. Enter 15% or 0.15 for a value that should display as 15%.

Multiplying by 100 and then applying the percentage format. If a formula already produces 0.15, formatting it as a percentage displays 15%. A formula that multiplies that result by 100 produces 15, which then displays as 1,500% when formatted. Usually, divide the part by the whole and apply the format; do not add an extra multiplication by 100.

Confusing a rate with a percentage amount. A rate of 20% is not the same as 20 units. To find 20% of 50, use a rate value of 20% and multiply by 50; the amount is 10. Keep the rate and the resulting amount in separate, clearly labelled cells.

Using the wrong comparison baseline. Percentage change is measured against the starting value. Divide the difference by the earlier value, not the later one. Also, a percentage change is not the same as the later value expressed as a share of the earlier value.

Assuming the display is the stored value. A cell showing 25% generally contains 0.25. That is expected: the number format presents the decimal as a percentage. Avoid changing the value to 25 simply because you want the cell to show 25%.

Tips

Use column headings such as “Completion rate,” “Share of total,” or “Month-over-month change” rather than a generic “Percent.” A clear heading helps readers understand what the numerator and denominator mean, and whether negative values are possible.

Apply a consistent number of decimal places across comparable values. Whole percentages are easy to scan in a summary, while two decimal places may be useful when small differences matter. Keep enough precision for the task, but do not imply that rounded display values are exact.

For a percentage column, format the full range once instead of formatting cells one by one. If some rows are blank, selecting the intended column range is still fine; blank cells remain blank. If the same column contains text labels or totals, select only the numeric percentage cells to avoid confusing display changes.

Use a note or a nearby label to define unusual rates. For example, state whether a completion rate is completed tasks divided by assigned tasks, and how missing or zero values are treated. This makes the sheet easier for someone else to interpret and helps you spot a formula that has the right format but the wrong meaning.

Troubleshooting

The cell shows 1,500% instead of 15%: The underlying value is probably 15. Replace it with 15% or 0.15. If the value comes from a formula, check whether it already multiplies by 100. In most cases, the percentage number format should handle the conversion for display.

The cell still shows a decimal: Select it and apply Format > Number > Percent again. Confirm that you selected the cell containing the value, not an adjacent cell. If you see the formula rather than its result, check whether the cell was set to plain text before the formula was entered; change it to a number format, then re-enter the formula.

A formula gives an error or an unexpected result: Check that the referenced cells contain numeric values and that the divisor is not zero or blank. In a part-over-whole calculation, verify that the part and whole are in the intended cells. A text entry such as “18 of 60” is not a numeric value for division; put the numbers in separate cells.

Only some rows display as percentages: Select the complete result range and apply the percent format. Check whether individual cells have a different format applied or whether formulas were filled down only part of the column. Formatting and formulas are separate: applying a format does not copy a missing formula into other rows.

The displayed value looks rounded or totals seem slightly off: Increase the displayed decimal places to inspect the underlying precision. The number format may round what you see without rounding the stored value. If you intentionally need rounded results, use a rounding method in the calculation only when that matches the requirements of your worksheet.

Frequently Asked Questions

How do I enter 5% in Google Sheets?
Type 5% into a cell and press Enter. You can also type 0.05, then apply Format > Number > Percent. Both represent the same rate.

Why does 0.5 become 50%?
That is the expected result. A percentage format displays the numeric value multiplied by 100 with a percent sign, so 0.5 appears as 50% and 1 appears as 100%.

Can I use a percentage in a formula?
Yes. A cell containing 10% can be used directly in a calculation, because Sheets stores it as 0.1. For example, multiplying an amount by that cell calculates one tenth of the amount. Format the result as a number, currency, or percentage according to what it means.

How do I show more than two decimal places?
Select the percentage cells and click the increase decimal places button in the toolbar until the display has the precision you want. This changes the displayed precision, not necessarily the stored value.

Can I enter a percentage above 100%?
Yes. Values above 1 display above 100%: for example, 1.25 displays as 125%. This is valid for cases such as growth relative to a baseline, but check that the rate’s meaning and denominator are appropriate.

Does formatting a cell change its value?
No. Formatting changes how a numeric value appears. A cell formatted as 25% normally holds 0.25, and formulas use that underlying value.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.