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

1. ## 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.

Thanks

2. 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
A
1 5
2 14.22
3
4
5 =trunc(A1+A2)

Now in cell A5 it will show 19 instead of 19.22

Edit:
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

3. 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.

4. ## 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

Dr_Evil

5. Thank you everyone.