SAP Knowledge Base Article - Preview

1619352 - Number formatting not retained when exporting a report to MS Excel format, from Crystal Reports

Symptom

  • Thousands separator character, and decimal character, are different in MS Excel.
  • Report exported to MS Excel format does not retain the format for the decimals and thousand separators.
  • Format specified for a numeric value in Crystal Reports for the thousand separator and decimal character are different when exported to MS Excel.


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

MS Excel, CR, Crystal Reports, export, Decimals, Thousand separators , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

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

Search for additional results

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