Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breakpoint will not stop Excel subroutine | Excel Discussion (Misc queries) | |||
Rounding off numbers in Excel 2003 | Excel Worksheet Functions | |||
How to stop Excel from changing the cell properties? | Excel Discussion (Misc queries) | |||
How do I stop Excel from making copies of files? | Excel Discussion (Misc queries) | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel |