Google Sheets Percentage: Show 2 Decimal Places Easily

To show percentages with two decimal places in Google Sheets, select the cells, choose Format > Number > Percent, then click Increase decimal places until two digits appear after the decimal point. For a fixed format, choose Format > Number > Custom number format and enter 0.00%.

What two decimal places mean for a percentage

A percentage format displays a stored number multiplied by 100, followed by a percent sign. The two decimal places are digits in the displayed percentage, not necessarily digits in the underlying value. For example, a stored value of 0.123456 can appear as 12.35% when formatted to two decimal places. The cell still holds 0.123456 unless you deliberately change it.

This distinction is useful because a percentage is often stored as a fraction: 1 represents 100%, 0.5 represents 50%, and 0.01 represents 1%. A display of 12.35% therefore corresponds to a value close to 0.1235. Formatting changes how the number looks; it does not automatically convert the stored value into a text string or remove its extra precision.

Two decimal places are common when small differences matter, such as comparing completion rates, survey results, or changes in a metric. They are not always necessary. A whole-number display may be easier to scan in a high-level dashboard, while a detailed analysis may need more precision. The right choice depends on what readers need to compare.

Format cells using the Number menu

In Google Sheets in a web browser, apply percentage formatting first, then set the number of displayed decimal places:

Select the cell or range you want to format. You can select a whole column by clicking its letter, but do that only if the column is meant for percentages.
Choose Format > Number > Percent. The selected values will display with percent signs.
On the toolbar, click Increase decimal places or Decrease decimal places until the display has exactly two digits after the decimal point.

The decimal-place controls change the number format in steps. If the selection initially shows no decimal digits, click Increase decimal places twice. If it shows too many, click Decrease decimal places until only two remain. Check a value with a nonzero third decimal place to confirm that the display is rounding as expected, rather than simply showing zeros.

Formatting a range also affects values entered into those formatted cells later, so you can prepare a dedicated percentage column in advance. Avoid applying percent formatting to a mixed-purpose column: ordinary counts such as 12 would then appear as 1200.00%.

Use a custom format for an exact display

For a precise, repeatable format, select the cells and open Format > Number > Custom number format. Enter 0.00% in the format field and apply it. The two zeros after the decimal point request two displayed digits, including trailing zeros. As a result, a value that equals 0.5 displays as 50.00%, rather than 50% or 50.0%.

A custom format is helpful when you want consistent presentation across a report, or when the toolbar controls have left different cells with different decimal counts. Apply it to the complete percentage range to standardize the appearance. If your spreadsheet uses a locale with different number punctuation, the decimal separator shown in the sheet may follow that locale; the custom number format dialog and preview can help you confirm the result.

Custom number formats can also include other display choices, but do not add complexity unless it serves a purpose. For a basic percentage with two decimal places, 0.00% is usually enough. The custom format still affects display only: it does not round the underlying value for later calculations.

Enter percentage values the right way

One frequent source of confusion is entering a percentage as a plain number. If you type 12.34% into a cell, Sheets interprets it as a percentage value equivalent to 0.1234. If you type 12.34 without the percent sign and then apply percentage formatting, the display becomes 1234.00%, because the stored number means 12.34, or 1,234 percent.

If a cell contains 12.34 to mean 12.34 percentage points, convert it to the fractional value Sheets expects before applying percentage formatting. With the unformatted percentage-point number in A2, =A2/100 returns 0.1234, which displays as 12.34% when the result is formatted as a percentage. This conversion is different from merely changing the cell format, so use it only when the original values were entered as whole percentage points.

For a column of new entries, the simplest approach is usually to format the cells as percentages first and then enter values with percent signs, such as 12.34%. If you are importing data, inspect a few raw values before formatting. Imported percentages may already be stored as fractions, or they may be stored as whole numbers; applying a display format cannot tell which interpretation the source intended.

Displayed rounding versus changing the value

Showing two decimal places rounds the display, but it does not make the stored number equal to the displayed figure. For example, 12.3456% may display as 12.35%, while a calculation using that cell can still use all of the original precision. This is generally useful: it keeps calculations more precise while making a table easier to read.

If you specifically need to change the value itself, use a rounding formula rather than relying on the visual format. With the original fractional percentage in A2—for example, 0.123456—=ROUND(A2,4) returns 0.1235. Formatting that result as a percentage with two decimal places displays 12.35%. Four decimal places in the fraction correspond to two decimal places in the percentage because percentage formatting scales the number by 100.

Rounding the stored value can affect later totals, averages, or comparisons, particularly when many rows are involved. Use display formatting when the goal is presentation. Use a rounding formula when a specification or later calculation genuinely requires rounded values, and keep the original data if you may need its full precision.

Choose between the toolbar and a formula

For most sheets, number formatting is the clearest option: it preserves numeric values and applies a consistent appearance. A formula is appropriate when you need a transformed or rounded result, not just a different display. A text formula or manually added percent sign is usually less suitable for calculations because the result may be treated as text rather than a number.

For example, suppose B2 contains a portion and C2 contains the total. With those values in B2 and C2, =B2/C2 calculates the share as a fraction. If B2 is 12 and C2 is 97, the result is approximately 0.123711; formatted as a percentage to two decimal places, it displays as 12.37%. Keep the formula result numeric and apply the percentage format to its cell.

Google Sheets and Excel both support percentage number formats, but their menus differ. In Excel for Microsoft 365 on Windows, use the Home tab’s Number group and its Percent Style and decimal-place controls. The steps above use Google Sheets’ browser menus, not Excel’s ribbon.

Fix common percentage-formatting problems

The result looks 100 times too large: Check whether the stored value is a whole percentage-point number such as 12.34 rather than a fraction such as 0.1234. Convert the data appropriately before applying percent formatting.
The cell shows too few decimal places: Increase decimal places on the toolbar or use the custom format 0.00%. Confirm that the selected cells—not a neighboring range—are being formatted.
The cell shows extra digits: Apply the custom format to the full range or use Decrease decimal places. Extra digits in the display do not necessarily mean the value is wrong.
The displayed value differs slightly from a calculator: The cell may contain more precision than it shows. Inspect the formula bar or temporarily increase the displayed decimal places to compare the underlying values.
Some entries do not change: Check whether they are text rather than numbers. Values imported with leading apostrophes, unusual spaces, or incompatible decimal punctuation may not behave like numeric percentages. Correct or convert the source data before relying on calculations.
A whole column changes unexpectedly: The column may contain counts or other values as well as percentages. Undo the format change if appropriate, then select only the percentage cells.

Make percentages easier to read in a report

Consistent formatting makes comparisons faster. Apply the same two-decimal format to values that readers are expected to compare, and use a clear heading such as Rate or Share so the unit is obvious. Do not mix 12.3%, 12.30%, and 12% in the same comparison unless the difference in precision is intentional.

Consider whether two decimal places imply more certainty than the source data supports. A survey estimate based on a small sample may not be meaningfully precise to a hundredth of a percentage point. Conversely, rates that differ only slightly may need two decimal places to distinguish them. Formatting communicates precision to readers, even though it does not create additional accuracy in the data.

Also distinguish percent change from percentage-point change. A movement from 10% to 12% is an increase of 2 percentage points; relative to the starting rate, it is a 20% increase. Both can be valid descriptions, but they answer different questions. Two decimal places control how either result is displayed, not which comparison is appropriate.

Frequently Asked Questions

How do I make Google Sheets show 12.34% instead of 12%?
Select the cell, choose Format > Number > Percent, and increase the decimal places until two digits show. You can also apply the custom number format 0.00%.

Does formatting a percentage to two decimals round the actual value?
No. Number formatting changes the display while preserving the stored value. Use a rounding formula such as =ROUND(A2,4) only if you need to change a fractional percentage value itself.

Why does 12.34 turn into 1234.00%?
Because 12.34 is interpreted as a number equal to more than twelve, not as 12.34 percentage points. Enter 12.34% directly, or divide a value intended as percentage points by 100 before applying percentage formatting.

Can I set two decimal places for a whole column?
Yes. Select the column by its letter and apply the percentage format and decimal-place setting. Do this only when the column is dedicated to percentage values, since ordinary numbers in it will also display as percentages.

Will a formula use the displayed two-decimal value?
Usually, calculations use the underlying stored value, including digits hidden by formatting. If a calculation must use rounded values, create rounded results with a formula and use those results deliberately.

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.