defaultNumberFormat PARAM tag



Assigns the default number format of values in the sheet.

Syntax

<PARAM NAME = "defaultNumberFormat" VALUE = "format">

Values

format
The number format:

Value Description
general (default) Displays up to 15 decimal places, a minus sign for negative values, no thousands separators, and no trailing zeros for decimal values.
fixed Displays up to 15 decimal places, a minus sign for negatives, and a leading zero for decimal values.
comma Displays up to 15 decimal places, thousands separators, and parentheses for negative values.
scientific Displays exponential notation with up to 15 decimal places and an exponent of up to 3 digits.
percent Displays numbers with a percent sign and up to 15 decimal places. For example, .05 is displayed as 5%.

In addition, you can specify one of the following formats:

International Number 1
International Number 2
International Number 3
International Number 4
International Number 5
Argentinean Peso
Australian Dollar
Austrian Schilling
Belgian Franc
Brazilian Real
British Pound
Canadian Dollar
Chinese Yuan
Czech Koruna
Danish Krone
ECU
Finnish Markka
French Franc
German Mark
Greek Drachma
Hong Kong Dollar
Hungarian Forint
Indian Rupee
Indonesian Rupiah
Irish Punt
Italian Lira
Japanese Yen
Luxembourg Franc
Malaysian Ringgit
Mexican Peso
Netherlands Guilder
New Zealand Dollar
Norwegian Krone
Polish Zloty
Portuguese Escudo
Romanian Leu
Russian Ruble
Singapore Dollar
Slovakian Koruna
Slovenian Tolar
South African Rand
South Korean Won
Spanish Peseta
Swedish Krona
Swiss Franc
Taiwan Dollar
Thai Baht
US Dollar
Other Country
ISO Argentinean Peso
ISO Australian Dollar
ISO Austrian Schilling
ISO Belgian Franc
ISO Brazilian Real
ISO British Pound
ISO Canadian Dollar
ISO Chinese Yuan
ISO Czech Koruna
ISO Danish Krone
ISO ECU
ISO Finnish Markka
ISO French Franc
ISO German Mark
ISO Greek Drachma
ISO Hong Kong Dollar
ISO Hungarian Forint
ISO Indian Rupee
ISO Indonesian Rupiah
ISO Irish Punt
ISO Italian Lira
ISO Japanese Yen
ISO Luxembourg Franc
ISO Malaysian Ringgit
ISO Mexican Peso
ISO Netherlands Guilder
ISO New Zealand Dollar
ISO Norwegian Krone
ISO Polish Zloty
ISO Portuguese Escudo
ISO Romanian Leu
ISO Russian Ruble
ISO Singapore Dollar
ISO Slovakian Koruna
ISO Slovenian Tolar
ISO South African Rand
ISO South Korean Won
ISO Spanish Peseta
ISO Swedish Krona
ISO Swiss Franc
ISO Taiwan Dollar
ISO Thai Baht
ISO US Dollar
ISO Other Country
Date Long International
Date Short International
31-Dec-96
31-Dec
Dec-96
December-96
December 31, 1996
Tuesday
Tuesday, December 31, 1996
Tue, Dec 31, 1996
1996/12/31
96/12/31
96/12
96.12.31
12.31
Date & Time Long International
Date & Time Short International
1996-12-31 (ISO)
1996-12-31-23:59:59 (ISO)
International Date 1
International Date 2
International Date 3
International Date 4
International Date 5
Time Long International
Time Short International
11:59:59 PM
1:59:59 PM
11:59 PM
1:59 PM
23:59:59
3:59:59
23:59
3:59
23:59:59 (ISO)
International Time 1
International Time 2
International Time 3
International Time 4
International Time 5
Label
Formula

See Also
defaultNumberFormatDecimals PARAM tag
DefaultNumberFormat property
NumberFormat property