Change negative symbol and dots to comma & vice versa

Topic Labels: Formulas
497 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am importing a financial summary from my bank which comes in CSV, and the amount of expenses comes in negative numbers. How can I convert a whole field with negative sign before the number to positive/delete the negative symbol?

And how can I switch the dot and comma symbol from US to international?
e.g 1,234.56 to 1.234,56

Thank you!

0 Replies 0