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

[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.

[Ron Rosenfeld]

On Tue, 24 May 2005 15:20:05 -0700, "Ian Elliott" <Ian
[email protected]> wrote:

>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