Fractions to Decimals 1

[catellor]

My question is i am trying to get fractional prices from Bloomberg Trading System to show up in a spread sheet as a decimal.

For Example:

The price in bloomberg will read 100-16 which in reality is 100 and 16/32 which would be in decimal 100.50.

I was wondering if there was anyway to create a formula to do this.

thanks bob

 

[bluedragon2]

If it is always /32, then:

=VALUE(LEFT(A1,FIND("-",A1)-1))+VALUE(RIGHT(A1,LEN(A1)-FIND("-",A1)))/32



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...