SAP Knowledge Base Article - Public

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

Symptom

Doc-Gen: Numbers with more than 15 digits get last digits changed to 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

  • Customer might use Scientific Notation;
  • Customer might use field as text, but it will be required to apply Excel Formulas to avoid scientific notation, such as CONCATENATE or TEXT;

See Also

  1. Last Digits are changed to Zeros when you type long numbers in cells of Excel: https://learn.microsoft.com/en-US/office/troubleshoot/excel/last-digits-changed-to-zeros
  2. How to exhibit full number without decimals on Excel Template for Document Generation in CPQ? : https://answers.sap.com/questions/13926878/how-to-exhibit-full-number-without-decimals-on-exc.html?childToView=13926879

Keywords

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

Product

SAP CPQ 2023