5 Ways To Remove Decimal From Number In Excel

Numbers with decimals can be a challenge to work with in Excel, especially when you need to remove them. Whether you're dealing with financial data, scientific calculations, or everyday arithmetic, knowing how to eliminate decimals from numbers in Excel is a valuable skill. In this article, we'll explore five different methods to remove decimals from numbers in Excel, catering to various situations and user needs.

The Importance of Removing Decimals in Excel

Before we dive into the methods, it's essential to understand why removing decimals is crucial in certain contexts. For instance:

• When dealing with monetary values, you might want to display only the whole number amount.
• In scientific calculations, decimals can sometimes be unnecessary or even misleading.
• When formatting data for reporting or presentation purposes, decimals might need to be removed for clarity or aesthetics.

Method 1: Using the TRUNC Function

The TRUNC function is a straightforward way to remove decimals from numbers in Excel. This function truncates a number to a specified number of digits, effectively removing any decimals.

Syntax: TRUNC(number, [num_digits])

• number is the value you want to truncate.
• [num_digits] is an optional argument specifying the number of digits to keep. If omitted, the function will truncate to the nearest integer.

Example:

Method 2: Using the INT Function

The INT function is another way to remove decimals from numbers in Excel. This function returns the integer part of a number, effectively discarding any decimal values.

Syntax: INT(number)

• number is the value you want to convert to an integer.

Example:

Method 3: Using the ROUND Function

The ROUND function can also be used to remove decimals from numbers in Excel, albeit with a slightly different approach. By rounding a number to a specified number of digits, you can effectively eliminate decimals.

Syntax: ROUND(number, [num_digits])

• number is the value you want to round.
• [num_digits] is an optional argument specifying the number of digits to keep. If omitted, the function will round to the nearest integer.

Example:

Method 4: Using Number Formatting

Another approach to removing decimals from numbers in Excel is to use number formatting. By applying a custom number format, you can display numbers without decimals.

1. Select the cells containing the numbers you want to format.
2. Go to the Home tab in the Excel ribbon.
3. Click on the Number Format button in the Number group.
4. Select Custom from the drop-down menu.
5. In the Format Cells dialog box, enter 0 (without the quotes) in the Type field.
6. Click OK to apply the format.

Method 5: Using VBA Macro

If you need to remove decimals from a large dataset or perform this task frequently, you can create a VBA macro to automate the process.

1. Press Alt + F11 to open the Visual Basic Editor.
2. In the Editor, go to Insert > Module to create a new module.
3. Paste the following code:

Sub RemoveDecimals()
    Selection.Value = VBA.Int(Selection.Value)
End Sub

4. Save the module by clicking File > Save (or press Ctrl + S).
5. To run the macro, select the cells containing the numbers you want to modify and press Alt + F8. Then, select the RemoveDecimals macro and click Run.

Gallery of Excel Functions:

FAQs:

By mastering these five methods, you'll be able to remove decimals from numbers in Excel with ease, making your data analysis and presentation tasks more efficient and effective.

Gallery of 5 Ways To Remove Decimal From Number In Excel