32nd halfs

G

George

How do I format a number to reflect a 32nd with a half value. I deal work
with 5 & 10 year bond futures which are quoted in 32nd but are carried to the
thousands. They are typically represented as 107'315 to represent 107 31.5/32?
 
D

David Biddulph

George said:
How do I format a number to reflect a 32nd with a half value. I deal work
with 5 & 10 year bond futures which are quoted in 32nd but are carried to
the
thousands. They are typically represented as 107'315 to represent 107
31.5/32?
Click to expand...

You could try =INT(MROUND(A1,1/64))&"'"&32*MOD(MROUND(A1,1/64),1)
 
Top