Max 2 decimal places for result / Integers 0 decimal places

Hi there,

I would like to know how to limit a number to a max of 2 decimals and allow for integers and 1 decimal numbers to be displayed accordingly.

For example, here is a data set.

- 1.3532
- 5
- 3.1
- 7.166343
- 6.2
- 7

The result is as follows:

- 1.35
- 5
- 3.1
- 7.17
- 6.2
- 7

Is this possible? If the 1 decimal numbers need to be 2, that would be acceptable.

Thank you,

Danny

Format your cells: 0.##

Nice addition MrShorty. I learned something again.

I'll respond, because I saw that you opened a new tread today with the same question and I wonder why you didn't respond to our input here.
If you don't respond, we don't know if our answers are clear.

Carrying out Mr Shorty's advice above.
Give the cells custom format 0.0# and add the Conditional format rule =(A1=INT(A1)) with format General.

I would like to hear your feedback.

Thank you guys. The solution works as desired.

And sorry about the second post with the same question! I'll be sure to check my library of previous posts before posting again.

Danny

Hi Danny,

Nice to hear that the solution works with 0, 1 or 2 decimals?
Would you consider adding reputation to the answers you feel deserve?
This can be done by clicking on Add reputation at the bottom left of the answer.