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

"Bernard Liengme" wrote:

If you could be happy with the data as displayed below, then use custom
format # ??/16
0.76 4.54 8.53
12/16 4 9/16 8 8/16

But you want data like
0.76 4.54 8.53
3/4 4 9/16 8 1/2

So you first need to round to the the nearest 16 then use the fraction
format # ??/??

I have used the formula
=ROUND(A1*16,0)*(1/16)
to do the rounding in the second row

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"jct6641" wrote in message
...
When converting a decimal to a fraction, I get some responses like 1/67
when
what I am looking for is increments of 1/64. Then I want to display 10/64
as
5/16 or 32/64 as 1/2 etc.
Can this be accomplished in an excel formula or combination of nested
formulas?