How to round off 0's in Excel ?
Results 1 to 5 of 5

Thread: How to round off 0's in Excel ?

  1. #1

    Question How to round off 0's in Excel ?

    Hello everyone,

    I need to know how to round off zeros in excel ?
    Suppose i have a value like 19.00, i dont want the .00 displayed.
    I know this sort of a question is totally unrelated to security, but it's an emergency.


  2. #2
    Senior Member Spyrus's Avatar
    Join Date
    Oct 2002
    i dont know if you are trying to do this in multiple fields but what you can do to just drop off the ending is to do this

    Number cell
    1 5
    2 14.22
    5 =trunc(A1+A2)

    Now in cell A5 it will show 19 instead of 19.22

    If you are trying to round the number use the same example but just put

    5 =round(A2, #of digits you want to round to)
    so =round(A2,2) would stay as 14.22
    =round(A2,0) would be 14
    Duct tape.....A whole lot of Duct Tape
    Spyware/Adaware problem click

  3. #3
    Senior Member
    Join Date
    Oct 2001
    Helsinki, Finland
    Format | Cells... | Decimal places: 0

    Alternatively, right-click the desired cells and choose the 'Format Cells...' from that menu.

    Yet, there should be buttons for increasing/decreasing decimals in the toolbar.
    Q: Why do computer scientists confuse Christmas and Halloween?
    A: Because Oct 31 = Dec 25

  4. #4
    Senior Member
    Join Date
    Dec 2002

    The Easy Way

    The easy way would be...

    right button click on 19.00 cell

    choose Format cells

    Click on number tab

    choose number

    and set the decimal places for the cell to 0

    Good Luck


  5. #5
    Thank you everyone.
    Thread closed.

Posting Permissions

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