SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Addict frankdux's Avatar
    Join Date
    Apr 2004
    Location
    Ashland, North Carolina
    Posts
    267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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?

  2. #2
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    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.

  3. #3
    SitePoint Addict frankdux's Avatar
    Join Date
    Apr 2004
    Location
    Ashland, North Carolina
    Posts
    267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  4. #4
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    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.

  5. #5
    SitePoint Addict frankdux's Avatar
    Join Date
    Apr 2004
    Location
    Ashland, North Carolina
    Posts
    267
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.


Bookmarks

Posting Permissions

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