Remove decimals in Excel

Removing decimals in Excel is necessary to simplify and enhance the readability of numbers, avoid inaccuracies caused by rounding errors, maintain consistent formatting across a spreadsheet, enable easier comparison and analysis of data, and provide flexibility for customizing number display according to specific needs.

How to Remove Decimal Places in Excel (5 Easy Methods)

In Microsoft Excel, decimal places are often used to represent precise values. However, there are situations where you may need to remove decimal places from your data for various reasons. In this tutorial, we will explore five easy methods to remove decimal places in Excel. Whether you want round off numbers or simply eliminate the decimal portion, these methods will help you achieve your desired result.

Method 1: Using the Decre Decimal Button The simplest way to remove decimal places in Excel is by using the Decrease Decimal button. Follow these steps:

1. Select the range of cells containing the decimal numbers.
2. Locate the “Decrease Decimal” button in the “Number” group on the Home tab of the Excel ribbon.
3. Click the button once to reduce the number of decimal places in the selected cells. Repeat if necessary until the desired decimal places are removed.

Method 2: Applying the Round Function The ROUND function in Excel allows you to round numbers to a specified number of decimal places or digits. Here’s how to use it:

1. Enter the formula “=ROUND(cell reference, num_digits)” in a blank cell, replacing “cell reference” with the reference to the cell containing the decimal number and “_digits” with the desired number of decimal places2. Press Enter to apply the formula and obtain the rounded value.
2. Copy the formula down to other cells if needed.

Method 3: Utilizing the INT or TRUNC Functions The INT and TRUNC functions can be used to remove decimal places without rounding the numbers. Follow these steps:

1. Enter the formula “=INT(cell reference)” or “=TRUNC(cell reference)” in a blank cell, replacing “cell reference” with the reference to the cell containing the decimal number.
2. Press Enter to apply the formula and obtain the integer value without decimal places.
3. Copy the formula down to other cells if necessary.

Method 4: Formatting Cells as Whole Numbers Formatting cells as whole numbers is another way to remove decimal places Excel. Here’s how1. Select the range of cells containing the decimal numbers. 2. Right-click on the selected cells and choose “Format Cells” from the context menu. 3. In the Format Cells dialog box, select the “Number” tab. 4. Choose “Number” from the Category list. 5. Set the Decimal places to 0. 6. Click OK to apply the formatting and remove the decimal places.

Method 5: Using Find and Replace If you have a large dataset with decimal places that need be removed, the Find and Replace feature can handy. Follow these steps:

1. Select the range of cells where you want to remove decimal places.
2. Press Ctrl + H to open the Find and Replace dialog box.
3. In the Find what field, enter “.”
4. Leave the Replace with field empty.
5. Click Replace All to remove all decimal places in the selected range.

Remove Decimals using Cell Formatting

To remove decimals from a number using cell formatting in Excel, you can follow these steps:

1. Open Microsoft Excel and navigate to the worksheet where you want to apply the formatting.
2. Select the cell or range of cells that contain the numbers you want to format.
3. Right-click on the selected cell(s) and choose “Format Cells” from the context menu. Alternatively, you can go the “Home” tab in the Excel ribbon, click on the “Number Format” dropdown arrow in the “Number” group, and selectFormat Cells.”
4. In theFormat Cells” dialog box, select the “Number” tab if it’s not already selected.
5. In the Category list, choose “Number” or “Currency,” depending on your preference.
6. In the “Decimal places” field, enter 0 (zero). This will remove all decimal places from the numbers.
7. Click “OK” to apply the formatting and close the dialog box.

Removing Decimals Without Rounding

In Microsoft Excel, numbers often contain decimal places. While rounding decimals is a common practice, there may be situations where you need to remove the decimal portion without rounding the number itself. This tutorial will guide you through various methods to achieve this in Excel.

Method 1: Using the INT Function The INT function in Excel returns the integer part of a number by truncating the decimal portion. Follow these steps to remove decimals without rounding using the INT function:

1. Enter your number with decimals in a cell.
2. an adjacent cell, use the formula “=INT(cell reference)”. For example, if your number is in cell A1, the formula would “=INT(A1)”.
3. Press Enter to get the result, which will be the integer part of the number without any decimals.

Method 2: Utilizing the TRUNC Function Similar to the INT function, the TRUNC function can be used to remove decimals without rounding. Here’s how do it:

1. Enter your number with decimals in a cell.
2. In an adjacent cell, use the formula “=TRUNC(cell reference, num_digits)”. The “num_digits” argument specifies the number of decimal places to keep. To remove all decimals, set “num_digits” to 0. For example, your number is in cell A1 and you want to remove all decimals, the formula would be “=TRUNC(A1, 0)”.
3. Press Enter to obtain the result, which will be the integer part of the number without rounding.

Method 3: Formatting Cells Excel provides formatting options that allow you to display numbers without decimals without actually changing their values. Follow these steps:

1. Select the cell or range of cells containing the numbers you want to format.
2. Right-click and choose “Format Cells” from the context menu.
3. In the Format Cells dialog box, go to the “Number” tab.
4. SelectCustom” from the Category list.
5. In the “Type” field, enter “0” (zero) or any desired number of zeros. For example, entering “0” will remove all decimals, while entering “0.00” will display up two decimal places.
6. Click “OK” to apply the formatting.

Remove digits after decimal with INT function or TRUNC function

The INT function in Excel returns the integer part of a number by truncating the decimal portion. It simply removes any digits after the decimal point without rounding the number. The syntax for the INT function is:

“=INT(number)

Here, "number" is the value or cell reference from which you want to remove the decimal portion.

For example, let's say you have a number 3.14159 in cell A1, and you want to remove the digits after the decimal point. You can use the INT function as follows:

=INT(A1)

This formula will return the value 3, which is the integer part of the number.

On the other hand, the TR function in Excel also removes the decimal portion of a number but gives you control over the number of decimal places to keep. The syntax for theUNC function is:

``=TRUNC(number, [_digits])

In this syntax, “number” is the value cell reference you want to truncate, and “num_digits” (optional) specifies the number of decimal places keep. If you omit the “num_digits” argument, the TR function removes all decimal places.

For example, let’s say you have a number 3.14159 in cell A1, and you want remove the digits after the decimal point. You can use theUNC function as follows:

=TRUNC(A1```

This formula will also return the value 3, removing all decimal places.

To summarize, both the INT and TRUNC functions in Excel can be used to remove digits after the decimal point. The INT function simply removes the decimal portion without rounding, while the TRUNC function allows you to specify the number of decimal places to keep.

Related posts:

Excel SUMPRODUCT Function Excel EVEN function Calculate standard error in Excel Excel RAND Function