How to Always Display Two Decimal Places in Excel 2013

Formatting cells properly in Excel 2013 can help to ensure that your data is not only displayed correctly, but can easily be digested by those that are viewing it. But aside from these factors, you might also want your data to look nice, too. There are a number of subjective ways that you can achieve this, but one helpful change to make is to display the same number of decimal places for all of the numbers in a given row or column.

Our guide below will show you how to format a selection of cells so that they all use the same number of decimal places.


Change Number Formatting in Excel 2013 to Include Two Decimal Places

The steps in this article are going to change the formatting options for some of the cells in your spreadsheet so that they always display two decimal places, even if one (or both) of those places are zeroes. Note that you can also achieve this by using currency formatting instead.


Step 1: Open the spreadsheet containing the cells that you wish to format.


Step 2: Use your mouse to select the cells that you would like to use two decimal places. You can select an entire row by clicking the row number at the left side of the sheet, an entire column by clicking the column letter at the top of the sheet, or you can select the entire sheet by clicking the button above row 1, and to the left of column A.

select the cells to format



Step 3: Right-click one of the selected cells, then click the Format Cells option.

right-click the selection, then click format cells



Step 4: Click the Number option in the column at the left side of the window, then confirm that the value in the Decimal places field at the center of the window is 2. You can then click the OK button at the bottom of the window to apply your changes.

show two decimal places for all cells in excel 2013



Would you like the decimal separator to be a different symbol than the one currently being used? Click here and learn where you can change this setting. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.