Round All Numbers Up?

[Tim]

Is there a way to make an entire spreadsheet round all
calculations up to the next highest integer, as opposed to
rounding down if the fraction is less than half? I'm
aware of the roundup function, but I need to apply this
format to the entire sheet for inventory purposes.

Pls email: (e-mail address removed)

Thx...

 

[Harlan Grove]

Is there a way to make an entire spreadsheet round all
calculations up to the next highest integer, as opposed to
rounding down if the fraction is less than half? I'm
aware of the roundup function, but I need to apply this
format to the entire sheet for inventory purposes.

Pls email: (e-mail address removed)

What you're talking about is NOT a format. You could achieve what you want
by formatting every numeric value as whole numbers, e.g., #,##0, then adding
0.5 to all numeric values (enter 0.5 in some cell, copy it, select the
entire worksheet, Edit > Goto, click on Special, select only constant
numbers, then Edit > Paste Special, Add as Values. This would affect all
constant numbers on the worksheet.

Alternatively, use another worksheet to filter the values from the original
one by each cell in the second worksheet referring to the corresponding cell
in the original worksheet plus 0.5. Format as whole numbers.