Excel cell number formatting
Posted by Michael Hollingsworth on September 21, 2001 9:56 AM
I would like to display fractions as 32nds, but listing the fraction as a decimal. For example, consider the number 103.75. I would like to display this as 103.24 as opposed to 103 24/32. Any suggestions? Thanks.
Posted by Barrie Davidson on September 21, 2001 10:07 AM
Could you use a formula? The following would give you your desired result.
=INT(A1)+(A1-INT(A1))*32/100
Regards,
BarrieBarrie Davidson
Posted by Mark W. on September 21, 2001 10:49 AM
I'm curious...
...what's the use for such a unconventional
representation?
Posted by lenze on September 24, 2001 5:39 AM
Michael: Check out the DOLLARDE & DOLLORFR functions.(You need the Analysis Tool Pack Add-In). Although these were designed to convert currencies, they can be used for any fractional conversions.
Posted by Michael Hollingsworth on September 28, 2001 6:23 AM
Re: I'm curious...
It's to be used for a bond trading application. Bonds are traded/quoted in 32nds, and 103.24 instead of 103 24/32 is a common representation.
Posted by Michael Hollingsworth on September 28, 2001 6:27 AM
Hi, thanks for the suggestions, but a formula doesn't work in the context of this app. I can use this formula in VB, but I was hoping there would be a clever way to simplay use a custom number format. Thanks everybody for your help.
