How to Get Rid of Decimals in Excel & Word

By John Smith

Microsoft Word and Excel are two separate programs in the Microsoft Office software package. Excel functions as a computer spreadsheet capable of complicated functions while Word is used word processor and document creator. Both programs allow you to use decimals to illustrate math values within the program. If you have a spreadsheet or word document full of long decimal numbers, you can customize each program to remove the decimal places and leave only the whole number. Each program requires a different method for removing decimals.

Excel

Step 1

Open you spreadsheet document and highlight the cells that contain decimal places. You can use the left mouse button to select and drag over the desired number of cells. If you want to customize the entire spreadsheet and remove all decimals, click the arrow in top left corner of the spreadsheet between the "A" and "1." Only use the select all if you do not have any other numbers in the spreadsheet. For instance, if you have some cells that with calendar dates then these will be changed along with the decimal places.

Step 2

Highlight the "Home" tab on the Excel main menu bar. Select the type of number category you want to keep the cells as using the "Number Format" box. For instance, choosing "Currency" will assume selected numbers are currency while selecting "Numbers" will everything as general numbers. If you have general numbers, currency and other number formats, you will need to change each type section by section, or sometimes cell by cell.

Step 3

Click the "Decrease Decimal" button in the "Number" section on the Excel menu bar until all decimal places disappear. This doesn't change the value of the numbers, it merely limits the displayed value so that it shows no decimal places.

Word

Step 1

Open the Word document and click "CTRL+H" to open the "Find and Replace" search tool.

Step 2

Click "More" at the bottom left corner to open up the options list. Check the box labeled "Use Wildcards."

Step 3

Type the following command in the "Find What" box: (.[0-9]{1,})

Step 4

Leave the "Replace With" space blank and click "Replace All." This will search for any decimal space followed directly by one or more numbers. All decimal places and the numbers following them will be deleted.