Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Change negative symbol and dots to comma & vice versa

Topic Labels: Formulas
251 0
Showing results for 
Search instead for 
Did you mean: 

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