Constant |
Value |
Description |
NumformatAccount
|
41 |
account value: 5,000
|
NumformatAccountcur
|
42 |
account value with currency symbol: $5,000
|
NumformatAccountD2
|
43 |
account value with decimal point: 5,000.00
|
NumformatAccountD2Cur
|
44 |
account value with currency symbol and decimal point: $ | 5,000.00 |
|
NumformatCurrencyD2Negbra
|
7 |
monetary value with decimal point, negative in brackets: ($1000.00)
|
NumformatCurrencyD2NegbraRed
|
8 |
monetary value with decimal point, negative is red in brackets: ($1000.00)
|
NumformatCurrencyNegbra
|
5 |
monetary value, negative in brackets: (1000$)
|
NumformatCurrencyNegbraRed
|
6 |
monetary value, negative is red in brackets: (1000$)
|
NumformatCustom000P0EPlus0
|
48 |
custom value: 15.2E+3
|
NumformatCustomDMon
|
16 |
custom date value: 11-Mar
|
NumformatCustomDMonYY
|
15 |
custom date value: 11-Mar-09
|
NumformatCustomH0MMSS
|
46 |
custom time value: 20:30:55
|
NumformatCustomHMM
|
20 |
custom date value: 8:30
|
NumformatCustomHMMAM
|
18 |
custom date value: 8:30 AM
|
NumformatCustomHMMSS
|
21 |
custom date value: 8:30:00
|
NumformatCustomHMMSSAM
|
19 |
custom date value: 8:30:00 AM
|
NumformatCustomMDYYYYHMM
|
22 |
custom datetime value: 3/11/2009 8:30
|
NumformatCustomMMSS
|
45 |
custom time value: 30:55
|
NumformatCustomMMSS0
|
47 |
custom time value: 30:55.0
|
NumformatCustomMonYY
|
17 |
custom date value: Mar-09
|
NumformatDate
|
14 |
date value, depends on OS settings: 3/11/2009
|
NumformatFractionOneDig
|
12 |
fraction value, one digit: 10 1/2
|
NumformatFractionTwoDig
|
13 |
fraction value, two digits: 10 23/95
|
NumformatGeneral
|
0 |
general format
|
NumformatNumber
|
1 |
general number: 1000
|
NumformatNumberD2
|
2 |
number with decimal point: 1000.00
|
NumformatNumberD2SepNegbra
|
39 |
number with thousands separator and decimal point, negative in brackets: (4,000.00)
|
NumformatNumberD2SepNegbraRed
|
40 |
number with thousands separator and decimal point, negative is red in brackets: (4,000.00)
|
NumformatNumberSep
|
3 |
number with thousands separator: 100,000
|
NumformatNumberSepD2
|
4 |
number with decimal point and thousands separator: 100,000.00
|
NumformatNumberSepNegbra
|
37 |
number with thousands separator, negative in brackets: (4,000)
|
NumformatNumberSepNegbraRed
|
38 |
number with thousands separator, negative is red in brackets: (4,000)
|
NumformatPercent
|
9 |
percent value, multiply the cell value by 100: 75%
|
NumformatPercentD2
|
10 |
percent value with decimal point, multiply the cell value by 100: 75.00%
|
NumformatScientificD2
|
11 |
scientific value with E character and decimal point: 10.00E+1
|
NumformatText
|
49 |
text value
|