Excel Get decimal part of a number Example
This tutorials shows how to Get decimal part of a number in Excel. If you need to get just de the decimal part of a number, you can use a simple formula based on the TRUNC function. Formula =number-TRUNC(number) Explanation In the example, cell C6 contains this formula: =B6-TRUNC(B6) This formula uses the TRUNC function …