HOW TO REMOVE CURRENCY FROM EXPORTED REPORTS IN CSV

Alan_Tang123Alan_Tang123 Member Posts: 1

When I export my reports (e.g. Profit and Loss), there is a SGD (singapore dollar) together with the value. Hence it is difficult to calculate the numbers in excel. How can I remove the country currency?

Comments

  • fabianoafabianoa Member Posts: 2

    If you're exporting as a CSV then that shouldn't be there, at least it isn't on my exports. You can do a find and replace within excel or use formulas to remove the currency text

Sign In or Register to comment.