Does Excel round numbers with a 5 in the tens place?
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. |
|
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com