Wrong format type for latitude and longitude

[kowalewski92]

Hi,

I have a problem with format type for columns that contains latitude and longitude. Please see attached screenshots:

Decimal format (and it is obviously that here I have comma):

https://imgur.com/a/0QllG

Text format (and it is strange that I have comma..):

https://imgur.com/a/ZxARK

The question is - How to replace comma with dot? Commas make troubles with translating latitude and longitude to address by nominatim.

Thank you for help.

[tjd]

Have you tried resetting your regional settings (File|Options & Settings|Options|Regional Settings) to a region that does not use a comma in place of a decimal point?  Another alternative would be to import as a text field and then, in Query Editor, do a "Replace Values" and replace "," with ".".