In table: how to change dot to comma

Hi!
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!

Tomek

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

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:

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