Custom Number Formatting

[ferrari_99]

Hi all,

I am interested in having my excel sheet reflect my prices in /32's so i did the format that i saw while browsing the interenet which is "# ??/32" The issue arrives when the number above in the equation is not a fixed number. So for example:

Price(Decimal) | Price(32's) | Excel Output
97.484375 97-15.5/32 97-16/32 ====> So thats a pretty big issue

97.53125 97-17/32 97-17/32 ====> Only work when number is not a decimal...

Keep in mind....the output still needs to be a value/number since calculations will run from it.


So thats is my issue, hope somebody can help me out. Thanks a lot!


Ferrari_99

 

[Andrew Poulsom]

Sorry, but you can't have decimals in the numerator or denominator of a fraction. Could you live with 64ths instead of 32nds?