-
February 9th, 2003, 05:18 PM
#1
Banned
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
-
February 9th, 2003, 05:35 PM
#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
Duct tape.....A whole lot of Duct Tape
Spyware/Adaware problem click
here
-
February 9th, 2003, 05:42 PM
#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.
Q: Why do computer scientists confuse Christmas and Halloween?
A: Because Oct 31 = Dec 25
-
February 9th, 2003, 05:42 PM
#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
-
February 9th, 2003, 06:01 PM
#5
Banned
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
-
Forum Rules
|
|