Hi everyone,
Let's say I have the number 7.09347824372 in cell A1, is there a way to keep the 2 decimals after the seven? So that 7.09 is left?
It is not a possibility to remove the decimals by using the 'decrease decimal' button, because I'm using concatenate text to use this number in a line of text. The formula then automatically uses all the decimals.
Would love to hear a solution.
Let's say I have the number 7.09347824372 in cell A1, is there a way to keep the 2 decimals after the seven? So that 7.09 is left?
It is not a possibility to remove the decimals by using the 'decrease decimal' button, because I'm using concatenate text to use this number in a line of text. The formula then automatically uses all the decimals.
Would love to hear a solution.