One way:

Format/Cells/Number/Custom # 0/32

In article ,
"Jon Horvath" 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