Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a three cells in to two one and a halfs? | New Users to Excel |