Export to excel issue - date format cannot be displayed properly

2461 Views

Dear all,

When we do a export to excel, if it has date format, we always have problem on displaying it in excel. Some of the date if we change the data format, it will be changed to the correct way. Others will remain the old data format. Any idea?

I've checked the SAP note. It doesn't work. Thank you in advance.

Regards,

Yuka

SAP Note:

Click the Excel symbol in the task bar in Business One

Save the file as ".txt"

Open Excel and open the file as a ".txt" (Select in "Files of type" All Files (,))

In the Text Import Wizard Select "Delimited" and for "Start import at row" 1.

Click "Next"

In the Text Import Wizard - Step 2, select 'tab' in "Delimiters", for "Text qualifier:" choose ""

Click "Next"

In the Text Import Wizard - Step 3, highlight the Date column and in "Column data format" check the radio button Date in the drop down menu beside Date you can set the date format you require

Click "Finish"