Excel Input mass adjustment

[Bestermarko17]

Hi All,

I am having an issue with the formatting of data files being extracted in quickbooks,

The extractions are balance sheets, income statements, tb's and transaction listings, however when importing these files to Alteryx, I came across that all the amounts were seen as 0, which by further investigation, the standard reports from quickbooks, all amounts have an = before the amount, for instance, if I see $6,500,000 in the bank account on the report, it will be shown as =6,500,000 and this is causing Alteryx to pull in all of the data as 0.

Does anyone have any tips regarding how to fix this in Alteryx, because it is a lot of work going into each month in the excel files and removing the =

Thanks in advance

[griffinwelsh]

@Bestermarko17 Are you able to upload a sample file that we can look at?