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.