cancel
Showing results for 
Search instead for 
Did you mean: 

How to exhibit full number without decimals on Excel Template for Document Generation in CPQ?

former_member39295
Associate
Associate
0 Kudos
334

How to exhibit full number without decimals on Excel Template for Document Generation in CPQ?
When trying to retrieve numbers like 1290235304131290068, Excel keeps parsing it in Scientific Notation.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member39295
Associate
Associate
0 Kudos

If numbers contain more than 15 digits, number after 15th might get changed to Zero. Microsoft provides some workarounds in below link:
Last digits are changed to zeros when you type long numbers in cells of Excel - Office | Microsoft L...

Excel behavior is to convert large numbers to scientific notation, on below page there are some workarounds:
Turn off scientific notation in Excel - Super User

former_member39295
Associate
Associate
0 Kudos

The cell, which will retrieve the value, should have the format configured.
One way to show huge numbers without decimals is to select Number format and remove the decimals in configuration.