| 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 | |||
Hybrid Mode
