Round All Numbers Up?

  • Thread starter Thread starter Tim
  • Start date Start date
T

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...
 
Tim said:
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)
Click to expand...

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.
 
Back
Top