Excel Formulas to Separate the Decimal Part of a Number!!

Assume that you have a list of values mixed with decimal values, here you need to get the values that are placed after the decimal points. How could you solve this? In this chapter, we will tell the simple tricks to separate the decimal part of a number in Excel. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• If you want to get the decimal part of a number, you can use the below formula.

=number-TRUNC(number)

Syntax Explanations:

• TRUNC – In Excel, the TRUNC functionhelps to return a truncated number of a given value.
• Range – It specifies the input range from your worksheet.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example.

• Here, we will show the input values in Column B.

• So, apply the above-given formula to the formula bar section and press the ENTER key.

• Finally, it will display the result as shown below.

Verdict:

Hope you like this article on how to separate the decimal part of a number in Excel. If you have any doubts regarding this topic or any other Excel/VBA related topic, ask in the comments section below. Thank you so much for visiting our site!! Click here to know more about *Geek Excel **and Excel Formulas *!! **

Read Also:

• Excel Formulas to Rank the Values based on Month ~ Simple Tricks!!
• Excel Formulas to Highlight the Rows with Blank Cells ~ Easy Tricks!!
• Formulas to Highlight Target Percentage with Conditional Formatting
• Excel Formulas to Highlight the Integer Values Only ~ A Simple Tutorial!!