Forum Discussion
Decimal separator after CSV import
Hi,
I need some help, please. I'm trying to import a csv file. The problem is that numbers are written with comma decimal separator, but my PC is working with dots as decimal separator.
In the p...
Thank you this works. But is it possible to change so that the query options are always set to a chosen language? No matter what language I choose as the Excels default language in the Excel option, the query option still has English(USA) as a default.
You may set PQ default locale only for current workbook
- Ok, thank you for the clarification