This can be caused if the report with currencies is exported in csv format instead of xml. Please follow the steps below to change the Report Excel Export Format under User Settings page.
- Click on the gear icon on the top right hand corner. - Go to Settings. - Go to Reports > Report Excel Export Format. - Select .xml (Excel XP and greater). - If you enable Separate Currency and Amount then, currency and amount will be split into two columns. - Click on Save. - This setting impacts only your account and not others. - All report exports will now be in .XML format.