Get the Decimal Part of a Number in Excel

Add to Favorites
Author: | Edits: don

How to get the decimal part of a number without any rounding in Excel.

This tip allows you to simply remove the whole number, integer, from the number in order to return the decimal portion of the number.

To do this, we need to use the TRUNC function inside a small formula.

If the number is in cell A1, use this formula to get the decimal part of the number:

=A1-TRUNC(A1)

f0a334eb8f4b5e5b886ab949a8b4a86f.png

This returns:

69f1daff15e8ed277ce91e080e3f49f6.png

As you can see, no rounding occurred; it simply output everything after the decimal.

This formula uses the TRUNC function to get the integer from cell A1 and then subtracts that integer from the number in cell A1, which leaves you with the decimal.

If you Evaluate the formula, you will see that the calculation looks like this: 123.8459-123

Notes

This is a simple formula that builds on the TRUNC function in Excel. Similarly, you can get the whole number, integer, part of a number.

Download the attached file to work with this example in Excel.


Excel Function: TRUNC()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Get the Integer Part of a Number in Excel
Tutorial: How to get the integer part, the whole number, from a number that has a decimal after it....
Get the First Word from a Cell in Excel
Tutorial: How to use a formula to get the first word from a cell in Excel. This works for a single c...
Remove Gridlines from Only Part of a Worksheet in Excel
Tutorial: How to remove gridlines from a part of a worksheet in Excel instead of the entire workshe...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...
Get the Numeric Value of any Constant in VBA
Tutorial: Two simple tricks to get the number value for constants in VBA and Macros for Excel. Cons...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Tutorial Details
Excel Function: TRUNC()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course