Hi Miguel,

What type of file is it?  If you don't already know the country of origin, I don't know how you can tell for sure by looking at the file.  What possible countries are you talking about?  Is it possible to look at the number format and work it out?  Often it's just the comma and period that are interchanged.

Regards

Phil

HI Philip,

Every month I need to download  csv files from Amazon Spain (my company is portuguese but sells in Spain, Italy and France, windows 10 is portuguese and Office 2016 is in English) and the values for sales (in Power Query) they have the following format:

• €200.23 I used to use  Replace values to get 200,23

• €2.256.95 With thousands that was a bigger problem. Separate columns at the thousand period, replace values and then merge columns to get 2 256,95

I needed to do this for multiple columns which was tedious.

Then I tried with “Locale” but I needed a lot of attempts to figure out which would make it (they all ended in Error), finally I tried with “Locale” English (Ireland) and everything went right.

Hence my question, a quick way to find the best "Locale" to change the number formatting.

Best regards,

Miguel

Hi Miguel,

If you know the file is from Spain then import it using the Spanish (Spain) locale es-ES?  Likewise for the other countries.

Phil