The number format of values in the range.
Set: Range.setNumberFormat(formatName, decimals)
Get: formatName = Range.getNumberFormat
decimals = Range.getNumberFormatDecimals
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
DefaultNumberFormat property
defaultNumberFormat PARAM tag
defaultNumberFormatDecimals PARAM tag