"DWR" wrote in message ...
Hi Bernard,

I am trying to conver the following into an excel sheet from the US Bonds
Market.

This is a tricky one.....today's closing price on Bonds was 119'215

That translates to 119 and 21.5 32nds of point.

In other words 119 21.5/32

How can I get excel to recognize this in this format?


Thanks!

David
....

Hi David.

In Bernard's absence try this:
119'215 in A1

=DOLLARDE(SUBSTITUTE(A1,"'","."),32)
That would give the numeric value

Formatted as # ?/64 maybe
the value would be shown as 119 43/64

The poor DOLLARDE is rarely used, so let it get some air :-)

Regards, Hans T.