I have a column with text looking like this:
123,123
123.123
123,123
123.123
I would like another column to parse this into decimal numbers, disregarding the different decimal separators (dot . and comma ,) so the result would be like this when locale has dot as separator:
123.123
123.123
123.123
123.123
And like this when locale has comma as separator:
123,123
123,123
123,123
123,123
How can I do this in the simplest way possible in Google Sheets?