Whenever a negative amount appears in an Exported CSV file, the amount is wrapped in <font color='red'> </font> !
if using excel, this simple formula will return the proper amount (removes the html wrap automatically)
IF(NOT(ISERROR(SEARCH("<font color='red'>",E2))),RIGHT(LEFT(E2,LEN(E2)-7),LEN(E2)-26),E2)
where E2 is the "amount" in buddi's csv output
if using excel, this simple formula will return the proper amount (removes the html wrap automatically)
IF(NOT(ISERROR(SEARCH("<font color='red'>",E2))),RIGHT(LEFT(E2,LEN(E2)-7),LEN(E2)-26),E2)
where E2 is the "amount" in buddi's csv output