stop Excel from rounding 22/32 to 11/16

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting time to decimal then rounding 2
How do I stop excel from changing fraction to lowest denominator? 3
Header of column which has minimum in row? 1
Convert list to table 1
NESTED ANDIF STATEMENTS 1
Overlap times formula/graph 1
How to find earliest record based on unique identifier from a list ofdata 4
Combining Multiple Rows of Data in Excel 4

Top