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 for Me (Login required).

Search for additional results

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