![]() ![]() So 5.1 would become 5 1/10 and 5.2 would become 5 2/10. Why converting a number from decimal to fraction, Google Sheets will make sure that it complies with the denominator that I have specified. In the above formula, I have specified the denominator of the fraction as 10. Suppose you have a dataset as shown below and you want to convert these decimals to fractions while having 10 as the denominator in the fraction.īelow is the formula that will do this: = TEXT ( A2, "# ?/10" ) ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |