The Integers element lets you customize the appearance of integers in a table cell.
After adding an Integers element to a custom number format, you can select it, click its disclosure triangle, and use the options in its pop-up menu to customize the element’s display attributes.
See Creating a Custom Number Format to learn how to add an Integers element.
To show or hide the thousands separator, choose Show Separator or Hide Separator.
To display zeros or spaces in front of the integer when it has fewer than a particular number of digits, choose “Show Zeros for Unused Digits” or “Use Spaces for Unused Digits.” To increase or decrease the number of zeros or hyphens displayed in the format field, choose Add Digit, Remove Digit, or “Number of Digits” on the pop-up menu, or use the Up Arrow or Down Arrow key to set the number of digits.
When you choose
|
This number
|
Is displayed like this
|
---|---|---|
Show Separator |
10000000 |
10,000,000 |
Hide Separator |
10000000 |
10000000 |
”Show Zeros for Unused Digits” and set “Number of Digits” to 6 |
100 |
000100 |