Export to excel issue - date format cannot be displayed properly

[Former Member]

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"

[Former Member]

What is your date format under Control Panel ?

[Former Member]

Hi........

You can change the format cell of the date column. All will come as per one syntax......

Regards,

Rahul

[Former Member]

Thanks for all the replies. I've changed the data format. Not helpful. Any more idea? Thanks

[sanju_ms]

Hi,

Please check with the date format of those cells in Excel sheet.

regards,

Sanju M S

[Former Member]

Dear Yuka,

You may check this thread:

Thanks,

Gordon