View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
J-EL J-EL is offline
external usenet poster
 
Posts: 1
Default Bond prices convert to decimals

I need to convert a bond price, which is expressed as (for example) : 99-07
and which really means 99 7/32. How can I do that in excel to be part of a
macro (like, convert everything with looks like 00-00 to 00 00/32, or even as
decimal ) . I'd appreciate any ideas anyone can offer me!!
Cheers