DefaultNumberFormat property



The default number format of values in the sheet.

Syntax

Set:     Sheet.setDefaultNumberFormat(format)
Get: format = Sheet.getDefaultNumberFormat

Applies to

Sheet object.

Data type

string. 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 property
NumberFormat property
defaultNumberFormat PARAM tag