In table: how to change dot to comma

so… everything was perfect until now: i just found that in four columns I have imported text values with dots.

How can I change values to numbers? And for the future - is there something like search and replace, for searching dots and replacing them with commas???

Regards, and thanks In advance for any help!


You could try changing the column type to number instead of text.

1 Like

OMG! The most straightforward solutions are always the most difficult! Sorry for that :slight_smile: question! I represent some kind of “excel-thinking” here…

THANK YOU ERIC :slight_smile:

1 Like

My pleasure glad I could help! All you need is an extra set of eyes sometimes… screenshots are key!

Not really but ctrl + F or Apple + F in the data editor will do the search part

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.