12-06-2017 06:23 AM
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 previous Excel versions, there was the possibility to convert them during the import wizard. Unfortunately, I'm not able to find the same option in the new import wizard (Power Query).
Thanks for all your answers
Luca
12-12-2017 10:44 AM
12-13-2017 02:44 AM
Hi Luca,
Two options if you use Power Query
1) In ribbon Data->Get Data->Query Options->Regional settings change the locale on French(France).
and importing CSV file use Tab as delimiter
2) Without above import as it is, remove automatic Change Type step if appears, select columns shall be converted to numbers, and from right click menu use Change Type->Using locale. Select French as the locale of origin and Decimal number as the type to convert.
01-12-2019 10:45 PM
Greetings would appreciate some help. New laptop with windows 10 & office 365. Unable to download csv. files to excel & separate info to columns with comma of the csv format. Region settings English South Africa. Region, Format, Additional Settings - list separator is a comma & even resetting, double OK button & reboot doesn't change the format.
01-21-2019 07:46 PM
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.
01-22-2019 06:58 AM
You may set PQ default locale only for current workbook
07-05-2020 06:25 AM
@Toto DeveloperThe decimal point is moved for some number. From my point of view this is caused by hiring people who think that they are superintelligent. Indeed in previous versions the decimal point was not moved; it used to work and is not any more. Who did this is responsible to restore the working version in its original state.
The famous example is that you go with a cushing to a roof an release all feathers in the wind. Then you start to collect all feathers and put them back in the pillow