You can specify the display format (formatting) for displaying numbers and text in labels, text boxes, tables, calendars, and other controls.
The display format of the output results can be controlled by specifying the following format in the "Format" column of the appropriate control.
Format List
| format specification | type | output (result) |
|---|---|---|
| 0 | integer | Integer rounded to the first decimal place. |
| 00 | integer (with head zero) |
Integer rounded to the first decimal place. Preceding zeros are added only if the number is less than two digits. |
| 0+ | integer (with head zero) |
Integer rounded to the first decimal place. Only if the specified number of digits of zeros is less than the specified number of digits of zeros, A zero is given to the head for the missing amount. *"0+" means "one or more 0s". |
| 0.0 | real number | Rounded to the first decimal place. |
| 00.00 | real number (with head zero) |
Rounded to the first decimal place. Leading zeros are added only when the integer part is less than two digits. |
| 0+.0+ | real number (with head zero) |
decimal fraction n + 1 Rounded to the first decimal place. n up to a point Indication. The integer part is the number of digits of 0 specified in the integer part of the format. Only if it is not met, a zero is added to the head for the deficiency. *"0+" means "one or more 0s". * "n is "specified in the decimal part of the format. Number of 0's". |
| 0,000 | Can every 3 digits mass delimiter |
Integer rounded to the first decimal place. Comma-separated every three digits only for four or more digits. |
| 0,000.0+ | Can every 3 digits mass delimiter |
decimal fraction n + 1 Rounded to the first decimal place. n up to a point Indication. Only if the integer part is 4 or more digits, Integer part separated by commas every 3 digits. *"0+" means "one or more 0s". * "n is "specified in the decimal part of the format. Number of 0's". |
| @ | character | Next letter. If not, leave blank (space). |
| & | character | Next letter. If not, do nothing (blank text). |
*The maximum number that can be formatted as an integer, a real number, or a number separated by commas every 3 digits is 15 digits.
legend
| logical input value | format specification | output (result) |
|---|---|---|
| 999.98 | 0 | 1000 |
| 999.98 | 00000 | 01000 |
| 999.98 | 0.0 | 1000.0 |
| 999.98 | 0000.000 | 0999.980 |
| 999.98 | 0,000 | 1,000 |
| 999.98 | 0,000.0 | 1,000.0 |
| 09012345678 | @@@-@@@@-@@@@ | 090-1234-5678 |
| 090123 | @@@-@@@@-@@@@ | 090-123 - |
| 09012345678 | &&&-&&&&-&&&& | 090-1234-5678 |
| 090123 | &&&-&&&&-&&&& | 090-123- |