The default number format of values in the sheet.
Set: Sheet.setDefaultNumberFormat(format)
Get: format = Sheet.getDefaultNumberFormat
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:
See also
DefaultNumberFormatDecimals property
NumberFormat property
defaultNumberFormat PARAM tag