Power Query | QuickBooks Online | Number Formatting .xls files

Hi Anonymous ,

You can also try replacing errors after data is imported into Power Query.

Select the column and find the data type option, change the type to "Decimal Number" or "Currency", depending on what is appropriate for your data.

If changing the data type results in errors, you can replace the errors with null or a default value.

Right-click on the column header and select "Replace Errors".

Enter the value you want to replace the errors with (e.g., null or 0).

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.