Why Do My Exported Reports Format Incorrectly in Excel?

This is due to your Operating Systems "Separator Settings". For your reports to format correctly, this setting must be set to ",".

To do this, start by clicking on the Start Button (Windows Button), and then typing "Control Panel".

Open "Control Panel", and then select "Region".

Capture87.JPG

A window will appear, and at the bottom of it will be "Additional Settings". Click on this button.

Capture88.JPG

Another window will appear on the screen. Find the "List Separator" options and set it to ",".

Capture86.JPG

Click "Apply" and then "OK". 

Your reports will now format correctly in Excel.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.

Need more help? Ask the community

Still got more questions?

Submit a request
Powered by Zendesk