on 2023 Jul 24 4:13 PM
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.
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.