ExcelBanter - stop Excel from rounding 22/32 to 11/16

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - stop Excel from rounding 22/32 to 11/16 (https://www.excelbanter.com/excel-discussion-misc-queries/44504-stop-excel-rounding-22-32-11-16-a.html)

Jon Horvath

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

JE McGimpsey

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

Jon Horvath

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

All times are GMT +1. The time now is 10:40 AM.