Forum Discussion
Format number not recognized
In the sample file you gave me I can't reproduce your problem.
You said that the Fee column is giving issues but from your file it looks like it's the Value column as it has values greater than 1000? The Fee column in your file only has numbers like 12.34
Anyway, looking at the XLS file (why are you using XLS and not XLSX?) the numbers are formatted correctly. Importing these with Power Query shouldn't pose an issue.
You show that your default regional setting is EN(US), so is mine so we are both using the same default locale and I can import ok.
When I import the file I can convert to decimal number without issue.
You said that you don't have an automatic 'Change Type' step in your query. So at what point are you trying to convert the values to decimal?
When you convert to decimal, it doesn't give an error? Rather it formats your numbers as 123.456.00?
In your XLS file do you see the number as 123.456,00 ?
If you manually try to convert the numbers to decimal using locale do you get this issue?
Phil