Hi - I have the following formula in a cell
=+"Tot: "&SUM(B14:R14)+SUM(B22:R22)
The problem is that the output is
Tot: -227.360000000001
This is due to the fact that one of the cells has a large number of digits after the .
Do anyone know how I can format the number to be ex. 0 digits after . and have the thousand seperator?
Thanks
=+"Tot: "&SUM(B14:R14)+SUM(B22:R22)
The problem is that the output is
Tot: -227.360000000001
This is due to the fact that one of the cells has a large number of digits after the .
Do anyone know how I can format the number to be ex. 0 digits after . and have the thousand seperator?
Thanks