Limited fraction cell format

  • Thread starter Thread starter vencopbrass
  • Start date Start date
V

vencopbrass

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 th
decimal is 4.6719 I want to show 4 11/16 NOT 4 43/64. I want th
fractions to round up to the nearest 16th, 8th, 4th or half. Is there
way to do this?
Thanks,
Lis
 
yes that's true but I want it to be either 1/4, or 3/8, or 5/16, etc...
based on what the decimal is. This is for fabrication and I can't tell
the shop to make something that is 5.7659 inches. I would tell them 5
13/16" which in decimal form is 5.8125. See? The cell would need to
round up to the nearest 16th or 8th or 4th or 2nd. I don't know how to
custom format cells. But using hte formats given I would have to make
it either 16th or 8th etc but not all.
Lisa
 
Back
Top