MrExcel Publishing
Your One Stop for Excel Tips & Solutions

displaying numbers in excel in 32'nds

Posted by Michelle on August 30, 2001 8:09 AM

I know there is a custom format to change a decimal to display in 32nds (i.e. .03125 as 1/32)
Is there anyway to show a decimal that is not on the even 32nd (i.e. .046875 as 1.5/32) Right now if I use the custom formatting it would round the .046875 to 2/32 and I don't want it to round I want to show the fraction. THANKS for any advise!!!

Posted by faster on August 30, 2001 8:12 AM

Create this format

# ??/32

Posted by michelle beattie on August 30, 2001 8:20 AM

:: Create this format

Faster, Thanks for the format tip, but that is what I am currently using but when I use that format it will round 7.5/32 to 8/32 and I need to be able to see the 7.5/32. Any other ideas??

Posted by Eric on August 30, 2001 9:38 AM

=32*A1&"/"&32 if your decimal value is in A1 (NT)