Formatting "Inch" Fractions?

[Michael D]

I know that I can format a cell for fractions and specify the number of digits, but is there a way to format where everything is rounded off to the nearest 1/16?

In other words, whenever there's a decimal in the cell, it gets converted into 1/16, 1/8, 3/16, 1/4, 5/16 etc. (something like 8/16 has NO use for me)

Ideas??

[martindwilson]

cant think of a way to do it in same cell but with your value in a1 in b1 put =MROUND(A1,1/16) format as fraction up to two digits

[Michael D]

Sweet! Thanks!