This can easily be done by changing the format code. In some cases, you may want to convert a number into a decimal value but have a fixed denominator.įor example, you may always want the denominator to be 5 or 10. If you need to change the format of the cells later, you can simply edit the second argument of the TEXT function Converting Decimals to Fractions with a Fixed Denominator
0 Comments
Leave a Reply. |