Menu

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

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Ron Rosenfeld

Posts: n/a

Default

On Tue, 24 May 2005 15:20:05 -0700, "Ian Elliott" <Ian
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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
why have column letters changed to numbers in excel	JCereda	Excel Discussion (Misc queries)	1	May 5th 05 12:36 PM
how write excel formula numbers in column => &=< between 20-40	ron	New Users to Excel	4	April 30th 05 02:37 PM
My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same.	Chrism	Excel Discussion (Misc queries)	4	April 12th 05 03:10 PM
How to convert Excel imported numbers from text to numbers?	Alden	Excel Discussion (Misc queries)	9	April 1st 05 09:51 PM
Excel should be able to compute the MOD of large numbers.	Gold Fish	Excel Worksheet Functions	5	December 3rd 04 09:10 AM

All times are GMT +1. The time now is 03:06 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement