Log In
Register
Home
May 27, 2014
Offline
change type with locale power query: how to know the origin of the file (Conutry, language ?!) in order to adjust the decimal punctuation?
October 5, 2010
Offline
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
May 27, 2014
Offline
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
1 Guest(s)
