Converting the round figure ....

[aligahk06]

Dear All,
I have a value in excel column in this way 2514.12, 3001.85, 2514.49 and so on vertically. I want the round figure in same cell like 2514, 3002 ,2514 . The cell only show round figure while summing and wont show the decimal part.


any help?

thanks,

Aligahk06

 

[AlanY]

can you not use the 'Decrease Decimal', see attached

oops, image didn't attached correctly

 

[Mackers]

Hi aligahk06

You can do one of two things:

1. Change the formatting of the cell (highlight and right click, go Format Cells, click Number and change decimal places to 0). This will not change the underlying value, so if your cells were 0.5 and 0.5, you could show them to 0 decimal places as 1 and 1, but if you added them together the result would be 1.
2. Use a rounding function such as =ROUND(TargetCell, 0). This will change the underlying value, so if your cells were 0.5 and 0.5 they would round to 1 and 1, and if you added them together you would get 2.

Hope that helps

Mackers