Rounding function

  • Thread starter Thread starter smorgen
  • Start date Start date
S

smorgen

Is there a way to round off a range of numbers, not just
one? Example 2.35, 4.78,7.21 I would like to be able to
round off all of these to a whole number, but not by
changing the decimal point. I need to have the value
change. Thanks.
 
Hi
one way (if your data is in column A):
- enter the following in B1
=ROUND(A1,0)
- copy this down
- select column B and copy the contents (CTRL+C)
- insert the contents with 'Edit - Paste Special - Values' to delete
the formulas
 
Back
Top