Skip to Content
avatar image
Former Member

Export to excel issue - date format cannot be displayed properly

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"

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jan 13, 2010 at 03:41 AM

    Dear Yuka,

    You may check this thread:

    incorrect-date-format-in-excel-reports

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2010 at 04:36 AM

    Hi,

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

    regards,

    Sanju M S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2010 at 05:44 AM

    Hi........

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

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2010 at 05:57 PM

    What is your date format under Control Panel ?

    Add comment
    10|10000 characters needed characters exceeded