There are numerous ways that you can format data in a spreadsheet in Microsoft Excel. Whether you need to fit your spreadsheet on one page, or you need to change something small about the way that data is displayed in a single cell, there is probably a way that you can do it. One of the more common ways to change the appearance of data is by adjust the formatting of the cell that contains the data.
The tutorial in this article will focus on changing the formatting of numbers that appear in your cells by eliminating the decimal places. The result of this will be numbers displayed in cells without a decimal point, or any numbers that follow that decimal point.
How to Reduce the Number of Decimal Places in an Excel 2013 Cell to Zero
We are going to be modifying the cell formatting for a single cell in the steps below, but you can apply this formatting to multiple cells by selecting all of the cells that you wish to change. This can be done by clicking the row number all the way to the left of a row, or the column letter at the top of a column. You can even select the entire spreadsheet by clicking the button above the row 1 heading, and to the left column of the column A heading.
Step 1: Open the spreadsheet in Excel 2013.
Step 2: Right-click the cell that you want to change, then click the Format Cells option.
Step 3: Click the Number option at the left side of the Format Cells window.
Step 4: Change the number in the field to the right of Decimal places to 0, then click the OK button at the bottom of the window.
Note that Excel will round the number in the cell down or up, based on the value of the decimal places.
If you find that a large spreadsheet that you have printed is difficult to read, then consider adding the top row to every page. This can improve reading dramatically, as it will be easy for your audience to tell what data belongs to which column.