Decimal separator

Ask for Help
1

Hi folks!

I just import a column with “comma” as decimal separator. It became a “string”, but I would like to use as a “numeric”. What are my options?

Thanks in advance!

UPDATE: I just noticed that the column have both separators, comma and point… :roll_eyes: :disappointed_relieved:

Eduardo

2

Is the comma definitely being used as a decimal separator and not a ‘thousands’ separator, e.g. 1,234,567.89?

In general, numbers are formatted based on the locale in the document settings, and they are parsed in a way that reflects that formatting. So to use the built-in parsing, you first need to choose a locale which causes existing numbers in your document to be displayed in the same way as they appear in your source data.