How to Get Rid of Decimals in Excel & Word

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

Excel

Video of the Day

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.

Advertisement

Video of the Day

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.

Advertisement

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.

Advertisement

Advertisement

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,})

Advertisement

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.

Advertisement

Advertisement

references