SAP Knowledge Base Article - Public

3359120 - Numbers with more than 15 digits get last digits changed to zero

Symptom

Numbers generated in excel sheet with more than 15 digits returns last digits as zero.

Environment

SAP SALES CLOUD CPQ

Reproducing the Issue

  1. Create a Quote
  2. Set a value that contains more than 15 digits
  3. When generating Excel Document, digits after 15th will get changed to 0.

Cause

Limitation on Microsoft Excel Software.

Resolution

  • It might be used Scientific Notation;
  • Cell might be formatted as text, but it will be required to apply Excel Formulas to avoid scientific notation, such as CONCATENATE or TEXT;
    • One way to use this workaround prior to uploading document into CPQ is to create an auxiliar tab that will contain the tag that, when parsed, becomes the long number;
    • In the Main Excel Tab, where it is the table that you want to show the result of the parsed tag, uses the CONCATENATE/CONCAT formula, referencing the CTX tag from the auxiliar tab;
    • Hide the auxiliar tab so end user cannot see it. 

See Also

  1. Last Digits are changed to Zeros when you type long numbers in cells of Excel;
  2. When I paste a long number, Excel turns it into scientific notation and changes numbers. - Microsoft Community Hub;
  3. How to exhibit full number without decimals on Excel Template for Document Generation in CPQ? ;
  4. Long numbers are displayed incorrectly in Excel - Microsoft 365 Apps | Microsoft Learn

Keywords

Excel, DocGen, Document Generation, Number Format, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Bug Filed

Product

SAP CPQ 2023