John,
Thanks for your efforts, but I've already considered proceeding as you
suggested. That may work for someone skilled in navigating Excel, but it is
not something I could turn over to a clerk to use regularly for a display of
four or more columns, with 15 to 20 subtotals in each column. I'm not certain
I'd want to contend with that either.

In <Format<Cell<Number<Custom one can enter the following new number
format to round numbers to the nearest 1,000: #,",000"

That only changes the displayed number, but does not change the value stored
for computations. Seems to me that rounding a number to the nearest 100 or
nearest 10 should also be possible if only we knew the entries to make in the
Custom Number Format screen. Maybe someone else out there has an answer.

Thanks again.

--
Leo


"John C" wrote:

Unless you have xl2007 (I don't), I don't think it is possible to do what you
want to do. What I recommend would be to use the round function, for example:

Say you are adding a bunch of numbers from col C to col G into col H
H2: =ROUND(SUM(C2:G2),IF(SUM(C2:G2)100,-2,-1))
this copied down to row 20.
But then, you have the total of col H in H22
H22: =ROUND(SUM(C2:G20),IF(SUM(C2:G2)100,-2,-1))

Essentially, in the cells you want to display to the nearest 100s or 10s,
use the rounding function, but when you are calculating, use the original
formula that helped you to arrive at the 'rounded' number.
--
John C


"Tarfun" wrote:

John, I know what I want to do, but not how to do it. I'm involved in
preparing a large organization's budget. The distinction between looking at
721 and 720, or even 700, in a $5-million budget is meaningless (and
distracting) so long as the subtotals are roundings of the real numbers. So I
ask again, what is the custom format for rounding numbers the nearest 100 or
nearest 10?
--
Leo


"John C" wrote:

What are you trying to do? If I understand what you are writing below, you
want a number, for example, 721, to be entered as 721, treated in all
calculations as 721, but what is displayed is only 700?
Wouldn't this cause some concern if, for example, you knew 2 numbers were
supposed to be added up, but it looked very wrong.
i.e.:
700 (721) + 600 (647) = 1400 (1368)

If not, please explain more.
--
John C


"Tarfun" wrote:

What is the custom format to display numbers to the nearest 100 or nearest
10, i.e., 721 be displyed as 700 or 720. I know that formattig a number that
way will retain its unrounded value in memory for all computations performed
using it. (Not so using the "Round" Function.)
--
Leo