stop Excel from rounding 22/32 to 11/16

Hi I have a spreadsheet that tracks bond prices which are quoted in 32nds

By default Excel will round 117 22/32 to 117 11/16

I cannot find a way to force it to show the 22/32

Is there a way?

Thanks!

Jon

One way:

Format/Cells/Number/Custom # 0/32

In article <[email protected]>,
"Jon Horvath" <[email protected]> wrote:

> Hi I have a spreadsheet that tracks bond prices which are quoted in 32nds
>
> By default Excel will round 117 22/32 to 117 11/16
>
> I cannot find a way to force it to show the 22/32
>
> Is there a way?
>
> Thanks!
>
> Jon

Thanks!

"JE McGimpsey" wrote:

> One way:
>
> Format/Cells/Number/Custom # 0/32
>
> In article <[email protected]>,
> "Jon Horvath" <[email protected]> wrote:
>
> > Hi I have a spreadsheet that tracks bond prices which are quoted in 32nds
> >
> > By default Excel will round 117 22/32 to 117 11/16
> >
> > I cannot find a way to force it to show the 22/32
> >
> > Is there a way?
> >
> > Thanks!
> >
> > Jon
>