Does Excel round numbers with a 5 in the tens place?

I

Ian Elliott

Any help appreciated.
I am comparing some numbers from a print-out and a spreadsheet, and the
spreadsheet numbers I will divide by 1000, then display them in a cell with a
custom format of #,###.
Excel apparently does not round numbers with a 5 in the tens place (i.e.
1261.5 when displayed with custom format #,### becomes 1261, not 1262, which
I expect).
So a number like 1,261,500 becomes 1261.5 when divided by 1,000, then is
displayed as 1,261 in the cell. I want it to display 1,262 but I can't think
of a easy way to do it.
The problem is the print-out will have a number like 1,262, but my
spreadsheet will have 1,261, and I want them to absolutely same for checking.
Thanks Again.
 
R

Ron Rosenfeld

On Tue, 24 May 2005 15:20:05 -0700, "Ian Elliott" <Ian
Any help appreciated.
I am comparing some numbers from a print-out and a spreadsheet, and the
spreadsheet numbers I will divide by 1000, then display them in a cell with a
custom format of #,###.
Excel apparently does not round numbers with a 5 in the tens place (i.e.
1261.5 when displayed with custom format #,### becomes 1261, not 1262, which
I expect).
So a number like 1,261,500 becomes 1261.5 when divided by 1,000, then is
displayed as 1,261 in the cell. I want it to display 1,262 but I can't think
of a easy way to do it.
The problem is the print-out will have a number like 1,262, but my
spreadsheet will have 1,261, and I want them to absolutely same for checking.
Thanks Again.

Have you tried it exactly as you describe the process? When I enter 1261500 in
some cell; then in another cell enter cell_ref/1000 and format it as you state,
I see 1,262 in the cell.

Is it possible that some of these cells do not contain EXACTLY 1261500 but
perhaps contain 1261499.9 but have a format with no decimal places?

If you don't require the commas in the output, you could use a custom format of

#,

on the original number.
--ron
 

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

Top