Select the area to format, right click-Format Cells go to fraction and that
should do it.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Cyberbiker" wrote:

I am trying to manipulate imported decimal data and have it show the results
as proper "tape measure" fractions, i.e. n/16, n/8, n/4, or n/2.

If I select say 49.370, I need it to display 49 3/8. I've searched but
haven't seen anything that quite covers this.

TIA