# Thread: Rounding-off an Excel Column

1. ## Rounding-off an Excel Column

I would like to take an Excel column with values like:

128.55
68.66
81.04
199.84

and round the values up so they would be like:

129.00
69.00
82.00
200.00

I'm a little rusty with Excel. Anyone have an idea?

1. Select all cells you want formatted.
2. Right-click and choose "Format Cells..."
3. In the "Number" tab, select "Number" from the Category list, and set the Decimal places to 0.
4. Click "OK" and watch your numbers get rounded correctly.

2. Vinnie, thanks for your reply. I knew you could do that, but I actually need to change the values. For example, through the way you suggest, 124.15 would appear as 124, but the cell's value is actually still 124.15. I need to change 124.15 so that it appears as 124.00 and the actual value would also be 124.00.

3. In that case, the formula you want is =ROUND(cell, 0).

Replace "cell" with the location of your numbered cell (i.e. "A1") and you'll get the modified value appearing in the cell you wrote the formula in.

4. Vinnie, thanks, that's what I was looking for. One last thing. Any idea how to use that formula on multiple cells at one time? I tried =ROUND(A1:A15, 0) but it doesn't work.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•