SAP Knowledge Base Article - Preview

3406957 - Date values are displayed in a different format in Excel - SAP PD

Symptom

  • Type of extended attribute is date in an extension file (XEM).
  • Dates are inserted in the dd/mm/yyyy format
  • Object list is customized to display the extended attribute.
  • The list is saved to *.xls or *.xlsx format to export it to Excel. 
  • Date values are displayed as mm/dd/yyyy in Excel.


Read more...

Environment

  • SAP PowerDesigner (PD) 16.7
  • Microsoft Excel 365
  • Windows Regional settings: French/France

Product

SAP PowerDesigner 16.7

Keywords

date, format, european, international, US , KBA , BC-SYB-PD , PowerDesigner , 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.