Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power Query | QuickBooks Online | Number Formatting .xls files

I currently have several reports ( .xls files ) being emailed from QuickBooks online to a Sharepoint location. When I open these reports, the number format is "custom". When I connect Power Query to ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Here's the number formatting in the .xls files:

 

 

  • mussaenda's avatar
    mussaenda
    Community Champion
    2 years ago

    Hi Anonymous , 

    you can solve your issue by going to the power query, remove the auto change type step for that field and change type using local 

     

    then select data type as decimal number

    and selectt he language of your currency

     

    Just take note that in Europe, "," means "." and vice versa.

     

    Hope this helps