View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cyberbiker Cyberbiker is offline
external usenet poster
 
Posts: 9
Default architectural fractions

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