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

Export to Excel - Amounts

46 Views

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.