Symptom
Numbers generated in excel sheet with more than 15 digits returns last digits as zero.
Environment
SAP SALES CLOUD CPQ
Reproducing the Issue
- Create a Quote
- Set a value that contains more than 15 digits
- 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
- Last Digits are changed to Zeros when you type long numbers in cells of Excel;
- When I paste a long number, Excel turns it into scientific notation and changes numbers. - Microsoft Community Hub;
- How to exhibit full number without decimals on Excel Template for Document Generation in CPQ? ;
- 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 , How To
Product
SAP CPQ 2023