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.