How to Keep a Trailing Zero in the Second Decimal Place in Excel

To keep a trailing zero in Excel, so 2.50 doesn’t turn into 2.5, select the cells and click Increase Decimal on the Home tab until two decimal places show. For a lasting setting, press Ctrl + 1, choose Number, and set Decimal places to 2.

These steps work in Excel for Microsoft 365 on Windows and Mac, Excel 2024, 2021, 2019, and 2016. The same Home tab buttons and Format Cells options are in Excel 2013 and 2010, and the Increase Decimal button and number formats are also in Excel for the web.

Why Excel Drops the Zero

New cells use the General number format. Microsoft’s Available number formats in Excel page explains that General shows a number mostly the way you type it, without a fixed number of decimal places. In math, 2.50 and 2.5 are the same value, so General shows the shorter version.

The zero isn’t lost. You only need to tell Excel how many decimal places to display.

Which Method Should You Use?

You want	Use
Prices, scores, or measurements that still add up	Number or Currency format with 2 decimal places
A one-time fix for a few cells	Increase Decimal button
The same look in many workbooks	Custom format code such as 0.00
2.50 inside a sentence or label	TEXT or FIXED function
Version numbers or codes like 10.10	Text format before you type

How to Keep the Second Decimal Place With Format Cells

This method sets the cells to always show two decimal places, including for numbers you type later.

1. Select the cells, or click a column letter to select the whole column.
2. On the Home tab, in the Number group, click the arrow next to the number format box (it usually says General).
3. Click More Number Formats. The Format Cells window opens on the Number tab.
4. In the Category list, click Number, or Currency for money.
5. Set Decimal places to 2. The Sample box previews the active cell.
6. Click OK.

2.5 now shows as 2.50, and 3 shows as 3.00. The Number category also has a Use 1000 Separator (,) checkbox and a list of ways to show negative numbers.

You can open the same window faster. Press Ctrl + 1, or right-click the selected cells and choose Format Cells. Microsoft’s Format numbers page notes that in Excel for the web you skip the Number tab step and go straight to the categories.

Quicker Way: Increase Decimal

1. Select the cells.
2. On the Home tab, find the Number group.
3. Click Increase Decimal until two digits show after the decimal point.

Each click adds one more decimal place, according to Microsoft’s Round a number to the decimal places I want article. Decrease Decimal, right next to it, removes one.

Chart labels have their own decimal setting, which you use when showing percentages on an Excel pie chart.

Keyboard Shortcuts for Two Decimal Places

Microsoft’s Excel keyboard shortcuts list includes a few that save clicks on Windows:

• Ctrl + Shift + ! applies the Number format with two decimal places, a thousands separator, and a minus sign for negatives.
• Ctrl + Shift + $ applies the Currency format with two decimal places and negatives in parentheses.
• Ctrl + 1 opens Format Cells.
• Ctrl + Shift + ~ puts the cells back to General, which removes the trailing zeros again.

Money and Percentages

• Currency: adds your default currency symbol and lets you choose the decimal places.
• Accounting: also for money, but it lines up the currency symbols and decimal points down a column.
• Percentage: multiplies the value by 100 and adds a % sign. Set decimal places to 2 so 0.125 shows as 12.50%. The Ctrl + Shift + % shortcut uses no decimal places, so follow it with Increase Decimal. For the math side, read about using a percentage formula in Excel.

Use a Custom Number Format

A custom format code gives you exact control. Each 0 after the decimal point is a digit Excel always shows, even when it’s a zero.

1. Select the cells and press Ctrl + 1.
2. Click Custom at the bottom of the Category list.
3. Type a code in the Type box, then click OK.

Code	2.5 shows as	1234.5 shows as
0.00	2.50	1234.50
#,##0.00	2.50	1,234.50
$#,##0.00	$2.50	$1,234.50
#,##0.00;(#,##0.00)	2.50	1,234.50, with negatives in parentheses

Custom codes are saved with the workbook, so you can pick the same code from the Custom list for other cells in that file.

Keep the Zero in Text and Formulas

Number formats don’t carry over when you join a number to text. If A2 holds 2.5 formatted as 2.50, the formula =”Total: “&A2 shows “Total: 2.5”. Wrap the number in a function that adds the decimal places:

• TEXT: =”Total: “&TEXT(A2,”$#,##0.00”) shows “Total: $2.50”. Microsoft’s TEXT function page lists more format codes.
• FIXED: =FIXED(A2,2) shows 2.50. Microsoft’s FIXED function page explains that it rounds to the number of decimals you choose and adds thousands separators unless you set the third argument to TRUE.

Both functions return text, not a number. Microsoft suggests keeping the original number in its own cell and using TEXT in a separate cell, because text results are harder to use in later calculations.

Keep Zeros in Version Numbers or Codes

Some entries aren’t really numbers. In software versions, 10.1 and 10.10 mean different things, and no number format can tell them apart once the zero is gone.

1. Select the empty cells.
2. Press Ctrl + 1, click Text, and click OK.
3. Type your entries. Excel keeps them exactly as typed.

Set the Text format first. If you type 10.10 into a General cell, Excel stores 10.1, and changing the cell to Text afterward won’t bring the zero back. For a single entry, type an apostrophe first, as in ‘10.10. The apostrophe doesn’t show in the cell.

Text entries can’t be used in math, and Excel may flag them with a green triangle. That’s fine for codes. For real numbers, use a number format instead.

Does This Change the Actual Number?

No. A number format only changes how the value looks. A cell showing 2.13 might still hold 2.125, and formulas use the full value. To change the stored value, use =ROUND(A2,2) in another cell, which Microsoft covers in its Round a number article.

Excel also has a workbook option called Set precision as displayed (File > Options > Advanced, under When calculating this workbook). It makes Excel use the displayed values in calculations. Microsoft’s Set rounding precision page warns that it can make your data increasingly inaccurate over time, so leave it off unless you’re sure you need it. ROUND is the safer choice.

Trailing Zeros in CSV Files

Microsoft’s list of formatting that isn’t transferred to other file formats says a CSV file saves the text and values as they’re displayed, and all formatting is lost. So:

• Saving as CSV: a cell showing 2.50 is written as 2.50, so format the cells before you save.
• Opening a CSV in Excel: the file has no formatting, so Excel uses General and 2.50 shows as 2.5. Reapply the Number format after opening.

Troubleshooting

The cell shows #####

The column is too narrow for the extra decimal places. Widen the column, or AutoFit it by double-clicking the right edge of the column heading.

The number still looks rounded

General rounds decimals when the cell isn’t wide enough to show the whole number. Widen the column or set a fixed number of decimal places with one of the methods above.

Increase Decimal does nothing

The value is probably stored as text. Look for a green triangle in the corner of the cell. Microsoft’s Convert numbers stored as text article explains how to select the cells, click the warning icon, and choose Convert to Number. Then apply the Number format.

Only some cells keep the zero

The format applies only to the cells you selected. Select the whole column by clicking its letter and apply the format again, so new entries pick it up too.

FAQs