cancel
Showing results for 
Search instead for 
Did you mean: 

FBL5N-Export file ISSUE

Former Member
0 Kudos

Hi Experts

While I am taking data of FBL5N(Customer data) in to following path

Menu-List-spreadsheet-Table then document date is coming in this pattern

Doc. date

40074

40169

40170

40170

And client require it in this path only.Please let me know that there is any other sollution or OSS note.

Regards

sachin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi sachin

Tell me this problem is in sap or in excel.means before export to excel is it showing correctly in SAP.

Thanks

Dipak

former_member2342
Active Contributor
0 Kudos

Dear

Consult your basis team

Regards

Former Member
0 Kudos

Hi Dipak

this issue is coming when i convert the data from SAP to Excel as per given path.But in SAP it is showing corrected.

Former Member
0 Kudos

Dear Sachin,

Your Windows Regional settings must coincide with the Date settings in SAP (User- Own Data- Defaults).

If not you can open the file and format the excel cells as date as I told you- f.e. 40074 is 18.09.2009.

Regards,

Milen.

Answers (1)

Answers (1)

Former Member
0 Kudos

Dear Sachin,

This seems to be an Excel issue.

Format the cells as Date please.

Regards,

Milen.