How to get numbers after commas in Excel

A rational number consists of two parts, an integer and a decimal. The whole part is the part before the comma, the part after the comma is called a decimal. Excel does not have specialized tools or functions to get numbers after commas. However, you can use the built-in tools to calculate whole and decimal parts.

How to get numbers after commas in Excel Picture 1

Use the TRUNC function to get the number before the comma

To get the part before the comma is very simple, you use the TRUNC function to truncate the part after the comma with the following syntax:

= TRUNC (number, [num_digits]).

Inside:

1. TRUNC: is the name of the function used to round a number to an integer by removing its decimal part.
2. Number: the original number.
3. Num_digits: A number that identifies the precision of truncation. The default value for num_digits is 0 (zero).

Note that INT and TRUNC are also functions that take integers. However, the INT function rounds down to the nearest integer based on the value of the fractional part of that number. While the TRUNC function takes an integer part by removing its fractional part.

The INT and TRUNC functions differ only when the original number is negative. TRUNC (-10.25) = -10 while INT (-10.25) = -11.

How to get numbers after commas in Excel Picture 2

Get the number after the comma

After you get the number before the comma (whole part) with the TRUNC function, you subtract the result of the TRUNC function and get the decimal.

How to get numbers after commas in Excel Picture 3

Combining the steps above, you can always use the following formula:

= rational numbers - TRUNC (rational numbers) .

In which rational numbers can be a position of cells containing data or a number to round. With the above formula, you get the same result:

How to get numbers after commas in Excel Picture 4

If you want the result to be a positive number, you use the ABS function to return the absolute value of the result by the formula = ABS (rational number - TRUNC (rational number)) .

How to get numbers after commas in Excel Picture 5

Above Software Tips showed you how to take the number after the comma in Excel. Good luck!