The fastest way to change decimal places

Open your spreadsheet and select the cells containing the numbers you want to adjust. Right-click and choose Format Cells, or press Ctrl+1 on Windows or Command+1 on Mac. In the Format Cells dialog, click the Numbers tab, then select Number from the Category list on the left. In the Decimal places field, type the number of decimal places you want to show — for example, 2 for currency or 0 for whole numbers. Click OK.

The numbers in your selected cells will now display with exactly that many decimal places. The actual values stored in the cells do not change — only what you see on screen. This matters if you use those cells in formulas, because the formulas still work with the full precision underneath.

Key Takeaways

  • Select your cells, press Ctrl+1 (Windows) or Command+1 (Mac), go to the Numbers tab, and type your decimal count in the Decimal places field.
  • Changing the display format does not change the actual value stored in the cell, so formulas and calculations remain accurate.
  • The Home tab ribbon also has increase and decrease decimal buttons for quick adjustments without opening a dialog.
  • Different number formats (currency, percentage, accounting) have their own decimal place settings and may override your choice.

Using the ribbon buttons for quick adjustments

If you want to add or remove one decimal place at a time without opening a dialog, use the ribbon buttons. Select your cells, then look at the Home tab. In the Number group, you will see two buttons: one with ".00" and a right arrow (Add Decimal Place) and one with ".00" and a left arrow (Delete Decimal Place). Click the right arrow to add a decimal place each time you click, or the left arrow to remove one.

This method is faster when you are fine-tuning a few cells and do not need to set an exact number all at once. Each click adds or removes one decimal place from the display. The buttons work on any selected range, from a single cell to hundreds of cells at once.

Formatting currency and percentages with decimals

Money and percentages often need specific decimal rules. Select your cells and open Format Cells (Ctrl+1 or Command+1). If you choose Currency from the Category list, you can set decimal places separately — most currencies default to 2, but you can change this to 0 for whole dollar amounts or 3 for currencies that use three decimal places. The same applies to Percentage: select it, then set your decimal places.

When you choose a category like Currency or Percentage, Excel may override your previous number format. This is normal. The decimal place setting you choose in that category will stick to those cells even if you later change the format back to Number.

What happens when you round versus format

Formatting changes only what appears on your screen. If a cell contains 3.14159 and you format it to show 2 decimal places, it displays as 3.14, but the cell still holds 3.14159. Any formula that uses that cell will calculate with the full value, not the rounded display.

If you actually need to round the value itself — so that formulas use the rounded number — use the ROUND function instead. Type =ROUND(A1,2) in a new cell to round the value in A1 to 2 decimal places. This creates a new number that is truly 3.14, not just displayed that way. Formatting is for display; ROUND is for changing the actual data.

Fixing decimals that appear in the wrong place

Sometimes numbers display with decimals in unexpected spots — for example, 1000 shows as 1.000 or 100 shows as 10.0 when you wanted whole numbers. This usually happens because the cell is formatted as Text instead of Number, or because the decimal place setting is too high for the data.

Select the cells and open Format Cells. Make sure the Category is set to Number, not Text. Set Decimal places to 0 if you want whole numbers, or to the number you actually need. If the cells still look wrong, the data itself may have been entered as text. In that case, you may need to re-enter the numbers or use the Text to Columns feature (Data tab) to convert them.

Keeping decimals consistent across a worksheet

If you want all numbers in a column or section to show the same decimal places, select the entire range at once before formatting. Click the column header to select a whole column, or drag to select a range of cells. Then open Format Cells and set your decimal places. Every cell in that selection will now display with the same precision.

You can also create a style so that future cells you add to that column inherit the same format. Right-click a cell with the formatting you want, choose Format Cells, then click New Style (or New Cell Style depending on your Excel version). Name it something like "Currency 2 Decimals" and click OK. Then any time you want to explore that format, you can select cells and choose the style from the Styles panel.

Frequently Asked Questions

Does changing decimal places affect my formulas?

No. Formatting only changes the display. The actual value in the cell stays the same, so any formula that references that cell will still calculate with the full precision. If you need formulas to use rounded numbers, use the ROUND function instead of just formatting.

Why do my decimals keep disappearing when I change the format?

If you select Currency or Percentage format, Excel sets a default decimal count for that category. You can change it in the Decimal places field. If decimals disappear after you close the dialog, check that you did not accidentally set Decimal places to 0, or that the cell format did not revert to a different category.

Can I set different decimal places for different cells in the same column?

Yes. Select only the cells you want to change, not the whole column. Format Cells will explore only to your selection. You can format one cell to 2 decimals and another in the same column to 0 decimals.

What is the difference between Format Cells and the ribbon buttons?

The ribbon buttons add or remove one decimal place per click and are fastest for small adjustments. Format Cells lets you type an exact number and set other options like currency symbol or negative number color all at once. Use the buttons for quick tweaks and Format Cells when you need precise control.

How do I remove all decimal places at once?

Select your cells, open Format Cells (Ctrl+1 or Command+1), set Decimal places to 0, and click OK. Or select the cells and click the Delete Decimal Place button on the Home tab ribbon multiple times until all decimals are gone.