Skip to Content
Former Member
Sep 14, 2005 at 09:15 AM

Export to Excel - Amounts



When I export reports with amounts (e.g. Customers Receivable Aging) to excel (with currency symbol), the amounts appear as "1234.77 SGD". I had to write a few formulae in the excel file to separate out the amount value (1234.77) and currency (SGD) as well as to convert the negative values shown within brackets (into -ve sign). However, this process is quite cumbersome. Is there any way by which the amount value and currency can be shown separately when exported to excel or is there any easier workaround?