I'm trying to use an excel formula to remove the semicolon, but even with the correct formula line I can not solve it. What I have now is this:
=SUBSTITUIR(SUBSTITUIR(K2;".";"");",00";"")
I'm trying to replace values that are like this: 2.000,00 to 2000 so that the whole column is modified, but the value stays 0,00
An image of the column.
Use the TEXTO formula to reconfigure the formatting of numbers. Since you want to remove the points (thousands separators) and the commas (decimal places), your formula will look like this:
=TEXTO(K2;"0")
... or, if you do not want to hide the decimals other than 0:
=TEXTO(K2;"Geral")
In your case, SUBSTITUIR only works when you are dealing with texts!
Change the formatting of cells to remove the thousands separator and reduce the number of decimal places to zero.
