Assigns the default number format of values in the sheet.
<PARAM NAME = "defaultNumberFormat" VALUE = "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:
See Also
defaultNumberFormatDecimals PARAM tag
DefaultNumberFormat property
NumberFormat property