Excel Formulas to Separate the Decimal Part of a Number!!
Tags: excelformula, excelformulas
Published: 2021-04-22 01:54:14

---
title: Excel Formulas to Separate the Decimal Part of a Number!!
published: true
date: 2021-04-15 10:38:07 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-separate-decimal-part/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get decimal parts](https://geekexcel.com/wp-content/uploads/2021/04/Get-decimal-parts.png)](https://geekexcel.com/excel-formulas-to-separate-decimal-part/get-decimal-parts/#main)<figcaption id="caption-attachment-32320">Get decimal parts</figcaption>

## General Formula:

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

**=number-[TRUNC](https://geekexcel.com/how-to-use-excel-trunc-function-in-office-365-with-examples/)(number)**

## Syntax Explanations:

- **TRUNC** – In Excel, the [**TRUNC function**](https://geekexcel.com/how-to-use-excel-trunc-function-in-office-365-with-examples/)helps 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**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-16.png)<figcaption id="caption-attachment-32321">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-5.png)<figcaption id="caption-attachment-32323">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-15.png)<figcaption id="caption-attachment-32322">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Rank the Values based on Month ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-rank-the-values-based-on-month/)**
- **[Excel Formulas to Highlight the Rows with Blank Cells ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-highlight-rows-with-blank-cells/)**
- **[Formulas to Highlight Target Percentage with Conditional Formatting](https://geekexcel.com/excel-formulas-to-highlight-target-percentage-with-conditional-formatting/)**
- **[Excel Formulas to Highlight the Integer Values Only ~ A Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-the-integer-values-only/)**