Bond prices convert to decimals
The formula would be quite simple:
=left(a1,2)+right(a1,2)/32
However, I suspect you also have prices over 100, so sometimes you would have 3
characters to the left of the '-'. If so:
=left(a1,find("-",a1)-1)+right(a1,2)/32
If you really need a macro, post back and I'm sure others will help you. Give
them an idea of how your data is store (ie, all over the sheet, in a column,
etc.)
--
Regards,
Fred
"J-EL" wrote in message
...
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
|