Limiting decimal points doing division.

[plitv001]

If I do per say =10/3 and the result would be 3.333333. How do I limit the output to only 2 decimal points. It's not an issue of not seeing the repeating 3 but I need it to display two places after the decimal.

I can use the =FIXED function but it will convert it to text.

Any other options to keep it as a number?

Thanks,
Pavel


DaddyLonglegs, Thank you for the help. I had done a cash on cash return ratio and it worked fantasticly. It got complicated but I got the result I was looking for.

[shg]

To limit the result to two decimals (and lose the precision), =ROUND(10/3, 2)

[plitv001]

Thank you very much.

[shg]

You're welcome