=MROUND(A1,1/16)

FormatCellsNumber tabCustom
In the Type box, enter:

# ??/??

--
Kind regards,

Niek Otten

"vencopbrass"
wrote in message
...

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


--
vencopbrass
------------------------------------------------------------------------
vencopbrass's Profile:
http://www.excelforum.com/member.php...o&userid=31868
View this thread: http://www.excelforum.com/showthread...hreadid=516876