View Single Post
  #1   Report Post  
Jon Horvath
 
Posts: n/a
Default 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