SAP Knowledge Base Article - Preview

1861296 - Incorrect Date format when exporting to Excel

Symptom

  • You are exporting a list containing Date field (Data Type=DATS) using the export to Microsoft Excel function.
  • The resulting spreadsheet file displays Date field cells incorrectly. i.e: datafield.PNG 


Read more...

Environment

  • SAP Basis releases 4.6C  to 7.00 with SAP Basis component lower than : SAPKB46C57, SAPKB62063, SAPKB64019, SAPKB70010
  • SAP GUI 7.10 and higher.
  • Microsoft Office 2007 and higher.

Product

SAP R/3 Enterprise 4.7x200 (Extension Set 2.00)

Keywords

Office 2007, Office 12, SET_FORMAT, XXL Export, Format Column, DATS, Data Type, (YYYYMMDD) stored as char(8), Date field , KBA , BC-FES-OFFI , SAP Desktop Office Integration , BC-FES-XXL , XXL List Viewer/Lotus Connections , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.