Thread: 32nd halfs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George
 
Posts: n/a
Default 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?