SAP Knowledge Base Article - Preview

1563080 - SAP GUI 7.20 - Export to Excel 2010 produces wrong date format

Symptom

  • Date and Time columns are displayed as numbers in Office 2010
  • Export to Excel shows wrong date and time 
  • Export to Excel 2010 shows date as number
  • Export to Excel 2010 shows time as number
  • Export to Excel shows wrong material number and date
  • Export to Excel 2007 shows date as number
  • Export to Excel 2007 shows time as number
  • Date cells are formatted as General and appear as number
  • Wrong column format in Excel Export
  • Columns (such as material number) are formatted as General and appear as scientific number with exponent e.g. 9.78019E+12


Read more...

Environment

  • SAP ECC
  • SAP ECC with Enhancement Packages
  • SAPGui for Windows 720
  • SAPGui for Windows 710

    • Product

    mySAP ERP 2004

    Keywords

    ALV export, Office 2010, Office 2007, SAPGui for Windows 710, SAPGui for Windows 720, Scientific notation, Date, Time, Numbers , KBA , BC-FES-GUI , SAP GUI for Windows , 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.