# Number Formats

> [HTML Version](number_formats.htm)


| **Symbol** | **Value** | **Description** | **Example** |
|------|------|------|------|
| NUMFMT\_GENERAL | 0 | general format |  |
| NUMFMT\_NUMBER | 1 | general number | 12345.6789 |
| NUMFMT\_NUMBER\_D2 | 2 | number with decimal point | 12345.67 |
| NUMFMT\_NUMBER\_SEP | 3 | number with thousands separator | 12,345 |
| NUMFMT\_NUMBER\_SEP\_D2 | 4 | number with decimal point and thousands separator | 12,345.67 |
| NUMFMT\_CURRENCY\_NEGBRA | 5 | monetary value, negative in brackets | (1000\$) |
| NUMFMT\_CURRENCY\_NEGBRARED | 6 | monetary value, negative red in brackets | (1000\$) |
| NUMFMT\_CURRENCY\_D2\_NEGBRA | 7 | monetary value with decimal point, negative in brackets | (\$1,000.00) |
| NUMFMT\_CURRENCY\_D2\_NEGBRARED | 8 | monetary value with decimal point, negative ed in brackets | (\$1,000.00) |
| NUMFMT\_PERCENT | 9 | percent value, multiply the cell value by 100 | 75% |
| NUMFMT\_PERCENT\_D2 | 10 | percent value with decimal point, multiply the cell value by 100 | 75.00% |
| NUMFMT\_SCIENTIFIC\_D2 | 11 | scientific value with E character and decimal point | 1.00E+02 |
| NUMFMT\_FRACTION\_ONEDIG | 12 | fraction value, one digit | 10 1/2 |
| NUMFMT\_FRACTION\_TWODIG | 13 | fraction value, two digits | 10 23/95 |
| NUMFMT\_DATE | 14 | date value, depends on OS settings | 3/11/2024 |
| NUMFMT\_CUSTOM\_D\_MON\_YY | 15 | custom date value | 11-Mar-24 |
| NUMFMT\_CUSTOM\_D\_MON | 16 | custom date value | 11-Mar |
| NUMFMT\_CUSTOM\_MON\_YY | 17 | custom date value | 9-Mar |
| NUMFMT\_CUSTOM\_HMM\_AM | 18 | custom date value | 8:30 AM |
| NUMFMT\_CUSTOM\_HMMSS\_AM | 19 | custom date value | 8:30:00 AM |
| NUMFMT\_CUSTOM\_HMM | 20 | custom date value | 8:30 |
| NUMFMT\_CUSTOM\_HMMSS | 21 | custom date value | 8:30:00 |
| NUMFMT\_CUSTOM\_MDYYYY\_HMM | 22 | custom datetime value | 3/11/2024 8:30 |
| NUMFMT\_NUMBER\_SEP\_NEGBRA | 37 | number with thousands separator, negative in brackets | \-4,000 |
| NUMFMT\_NUMBER\_SEP\_NEGBRARED | 38 | number with thousands separator, negative red in brackets | \-4,000 |
| NUMFMT\_NUMBER\_D2\_SEP\_NEGBRA | 39 | number with thousands separator \& decimal point, negative in brackets | \-4,000.00 |
| NUMFMT\_NUMBER\_D2\_SEP\_NEGBRARED | 40 | number with thousands separator \& decimal point, negative red in brackets | \-4,000.00 |
| NUMFMT\_ACCOUNT | 41 | account value | 5,000 |
| NUMFMT\_ACCOUNTCUR | 42 | account value with currency symbol | AA\$ 5,000 |
| NUMFMT\_ACCOUNT\_D2 | 43 | account value with decimal point | 5,000.00 |
| NUMFMT\_ACCOUNT\_D2\_CUR | 44 | account value with currency symbol and decimal point | AA\$ 5,000.00 |
| NUMFMT\_CUSTOM\_MMSS | 45 | custom time value | 30:55:00 |
| NUMFMT\_CUSTOM\_H0MMSS | 46 | custom time value | 20:30:55 |
| NUMFMT\_CUSTOM\_MMSS0 | 47 | custom time value | 30:55.0 |
| NUMFMT\_CUSTOM\_000P0E\_PLUS0 | 48 | custom value | 1.52E+04 |
| NUMFMT\_TEXT | 49 | text value | any text |
| NUMFMTX\_IMAGE | 60 | Image filespec (host format PNG, JPG, BMP, or TIF. For example: c:\\images\\girl.jpg. | any image |