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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks!
"JE McGimpsey" wrote: 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 |
Reply |
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 |