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…
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.