To access Excel import and export features:
1. Open the Options window.
2. Select Tools > Data Exchange.
3. Select Exchange with third party tools > Excel.
4. Make sure that the following check boxes are selected:
• Activates the Excel import (*.xls, *.xlsx),
• Activates the Excel export (*.xls, *.xlsx),
• Enables the Excel Template Builder (*.xls, *.xlsx).
By default, date format of files generated through Excel import and export is: yyyy/mm/dd.
To modify this format:
1. Open the Options window.
2. Select Tools > Data Exchange.
3. Select Exchange with third party tools > Excel.
4. In the option Excel import/export: Date Format, define the format of your choice.
5. Click OK.
