32nd halfs
 

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?

32nd halfs
 

"George" wrote in message
...
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?

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