Hi, I would like to format cells to show a decimal as a fraction. However I want the fraction to be only selected ones. Ex: if the decimal is 4.6719 I want to show 4 11/16 NOT 4 43/64. I want the fractions to round up to the nearest 16th, 8th, 4th or half. Is there a way to do this?
Thanks,
Lisa