To get just the decimal part of a number, you can use a formula based on the TRUNC function. In the example shown, the formula in cell C6 is: =B6-TRUNC(B6)
確定! 回上一頁