SAP Knowledge Base Article - Preview

1212778 - String fields turning into exponential numbers when exporting a report to CSV format from Crystal Reports

Symptom

  • Expotential numbers displays in MS Excel.
  • When exporting a report to CSV format from Crystal Reports, that contains a database field or formula field of data type string that contains a value like: 2E158,  the string value is read as being a numeric field and returned as a exponential value like: 2.00E+158 in MS Excel.
  • How can you export a report to CSV format without having a string field being converted to a numeric field and thus displaying the value incorrectly as an exponential value?


Read more...

Environment

  • SAP Crystal Rpeorts 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

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

Keywords

CSV COMMA SEPARATED VALUES EXPORT EXPONENTIAL STRING EXPORTING Seagate Crystal Reports exporting to CSV returning exponential values , c2008338, CR , 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.