Hi,
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?
Thanks.