Symbol |
Value |
Description |
Example |
---|---|---|---|
NUMFMT_GENERAL |
0 |
general format |
|
NUMFMT_NUMBER |
1 |
general number |
1000 |
NUMFMT_NUMBER_D2 |
2 |
number with decimal point |
1000 |
NUMFMT_NUMBER_SEP |
3 |
number with thousands separator |
100,000 |
NUMFMT_NUMBER_SEP_D2 |
4 |
number with decimal point and thousands separator |
100,000.00 |
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/2009 |
NUMFMT_CUSTOM_D_MON_YY |
15 |
custom date value |
11-Mar-09 |
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/2009 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 |