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
|