Google Sheets: Show Percentages to 2 Decimal Places

To show percentages with two decimal places in Google Sheets, select the cells and choose Format > Number > Percent, then use the toolbar’s increase-decimal button until two digits appear after the decimal point. For a fixed two-place format, choose Format > Number > Custom number format, enter 0.00%, and select Apply.

What two decimal places means for a percentage

Two decimal places means two digits appear to the right of the percent sign’s decimal point: examples include 7.25%, 50.00%, and 100.00%. In the cell’s underlying value, however, a percentage is stored as a decimal fraction. A value of 0.0725 is displayed as 7.25% when percentage formatting is applied; 1 is displayed as 100%.

That distinction explains a common source of confusion. If a cell contains 0.075, percentage formatting displays 7.5%, not 0.075%. To show two decimal places, the display becomes 7.50%. The extra zero communicates the chosen display precision; it does not change the value itself.

Likewise, percentage formatting scales the displayed number by 100. If you type 12.34 into a cell and then apply percentage format, Sheets displays 1234.00%, because the stored value is 12.34. For a value of 12.34%, enter 12.34% or enter 0.1234 and format it as a percentage.

Set two decimal places with the menu

The menu method is dependable when you want to apply percentage formatting and then set the number of displayed digits. In Google Sheets in a web browser:

Select one cell, a range, or an entire column by clicking its letter.
Choose Format > Number > Percent. The selected values will display as percentages.
With the cells still selected, click the toolbar button to increase decimal places until each value shows two digits after the decimal point.

For example, a stored value of 0.086 becomes 8.60% after percentage formatting and setting two decimal places. If the value is already in percentage format, you can skip the first menu choice and use the decimal-place control. The control changes the selected cells’ number format, not the values or formulas in them.

Google Sheets may retain the selected format when you enter new values into already formatted cells. If you paste data from another source, check the result: pasted formatting can sometimes replace the destination format. You can reapply the percentage format to the whole range if necessary.

Use a custom number format for a fixed display

If you want every selected cell to show exactly two decimal places, use a custom format. Select the range, go to Format > Number > Custom number format, type 0.00% in the format field, and click Apply. The two zeroes after the decimal point require two displayed digits, including trailing zeroes. For instance, 0.5 appears as 50.00%, and 0.1234 appears as 12.34%.

Custom formats are useful when a table or report needs consistent alignment and precision. A value that would otherwise appear as 8% can be shown as 8.00%, making the level of detail consistent down the column. To show a variable number of decimal places instead, a format such as 0.##% can leave off unnecessary trailing digits, so 0.5 appears as 50% while 0.1234 appears as 12.34%.

A number format changes how a number looks, not its stored value. You can still use a cell with a custom percentage format in arithmetic, sorting, charts, and other calculations as a number. Be careful not to use quotation marks around the format pattern in the custom-format field; enter the pattern itself.

Displayed precision versus rounding the value

Formatting to two places is not the same as rounding the stored number. Suppose a cell contains 0.123456. A percentage format with two decimal places displays 12.35%, but the underlying value remains 0.123456. Other calculations can still use all of those stored digits, even though they are not visible in the cell.

That is usually desirable: keep precise source data and control only how it appears. If you specifically need to change the value used by later calculations, use a rounding formula instead. With the unrounded decimal value in A2, =ROUND(A2,4) returns 0.1235; formatted as a percentage with two decimal places, that displays as 12.35%. The four in the formula is needed because a percentage display shifts the decimal two places: two percentage decimal places correspond to four decimal places in the stored fraction.

For another illustration, with 0.123456 in A2, =TEXT(A2,"0.00%") returns the text value 12.35%. This is handy when creating a sentence or label, but the result is text rather than a numeric percentage. That can affect sorting and calculations, so use ordinary cell formatting when the result needs to remain a number.

Rounding can affect later totals or comparisons. For example, separately rounding multiple rates before using them in a calculation may produce a slightly different result from calculating with their full precision and rounding only the final display. Decide whether the task calls for a visual presentation change or an actual rounded value, and keep the unrounded source values if you may need them.

Apply the format to a column or a new set of entries

For a percentage column, select the cells that should use the format before applying it. Clicking the column letter selects the whole column, which is convenient when future entries should follow the same display style. If the sheet has a header, formatting the whole column generally leaves text headings unchanged, but you can instead select only the data range to avoid changing the header’s format.

For a range that already contains values, format the range once rather than changing each cell individually. You can also copy a correctly formatted cell and use Edit > Paste special > Paste format only on another range when you want to copy its appearance without replacing the destination values. Check that the source cell is actually formatted as a percentage before copying its format.

When entering a new percentage, the percent sign is a useful cue: typing 8.5% represents 0.085 as the stored value. If you type 8.5 and later format it as a percentage, it represents 850%. Establishing whether a data source provides percent units (such as 8.5) or decimal fractions (such as 0.085) prevents large display errors.

Common problems and how to fix them

The result looks 100 times too large. The cell probably contains a whole-number percentage, such as 8.5, instead of the decimal fraction 0.085. Verify the source convention, then correct the input or convert it before formatting.
Only one decimal place appears. The cell may be using the basic Percent format with its current decimal setting. Increase decimal places once more or apply the custom format 0.00%.
Trailing zeroes disappear. A format with optional decimal placeholders can hide them. Use two required zeroes in 0.00% if values such as 6.00% must retain both digits.
A formula result does not look like a percentage. A formula’s result may be numeric but formatted as a plain number. Select the result cell and apply Percent or the custom percentage format; you usually do not need to rewrite the formula.
The decimal mark differs from the example. Sheets’ display conventions can depend on the spreadsheet’s locale. Check File > Settings if the sheet uses a different regional convention; changing a locale can affect date, number, and currency display across the spreadsheet.
The cell shows a dash or unexpected text. Check for a custom format, a formula returning text, or a value stored as text. Applying number formatting alone cannot turn text into a numeric value.

Choose the right method for your sheet

Use the toolbar decimal-place control for a quick adjustment to selected cells. Choose the custom format 0.00% when a report needs a consistent, fixed two decimal places, including zeroes at the end. Leave the stored values unrounded unless a calculation or data requirement specifically calls for rounded values.

Google Sheets and Excel both support percentage number formatting, but this article’s menu paths are for Sheets in a web browser. Excel for Microsoft 365 on Windows uses its own ribbon and number-format controls, so the Google Sheets menu path does not apply there. In either program, the central distinction is the same: a number format controls display, while a rounding operation changes the numeric result used in subsequent calculations.

Frequently Asked Questions

How do I make all percentages show two decimal places in Google Sheets?
Select the cells or column, choose Format > Number > Custom number format, enter 0.00%, and click Apply. This displays two decimal places, including trailing zeroes.

Why does 0.25 show as 25.00%?
Because percentage formatting displays a decimal fraction multiplied by 100. The stored value 0.25 represents 25%, and the two decimal places are only part of its display format.

Does formatting to two decimals round the value?
No. It rounds the displayed representation but preserves the underlying value. Use a rounding formula only if later calculations must use the rounded result.

How do I show 5% as 5.00% instead of 5%?
Apply the custom number format 0.00%. Its required zero placeholders show trailing zeroes rather than suppressing them.

Can I keep the percentage numeric after formatting it?
Yes. Applying a number format keeps the cell’s value numeric. A formula such as TEXT creates a text string, so use cell formatting if you need to calculate with the percentage afterward.

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.