Please enable JavaScript to view this site.

A-Shell Consolidated Reference

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