To get the decimal part of the number, here’s what you can do:
You can use the help of TRUNC Function in Excel. Here’s an example for how to use it:
As you can see, we have taken a bunch of numbers, now to get their decimal values, here’s what we do:
We select the “number value” after starting a formula.
*Always remember to start a formula, all you have to is put an =
After the same, you put the TRUNC Function.
Do not forget to put the “minus” sign between your number value and the TRUNC Function. Because only through that sign the decimal values will be separated from the number values.
Basically, it’s like, “that’s how it works!”.
The =TRUNC( Function requires number as well as number digits.
All we have to is fill-in the number, i.e. again our “number value” C2.
Now all we have to is press “enter” and BAMMM!
As you can see, all the decimal values appear to your screen.
It’s easy, isn’t it?
Learn more Excel Formulas here.