Excel.NumberFormatCategory enum
Represents a category of number formats.
Remarks
[Api set: ExcelApi 1.12]
Fields
| accounting = "Accounting" | Accounting formats line up the currency symbols and decimal points in a column.
|
| currency = "Currency" | Currency formats are used for general monetary values. Use Accounting formats to align decimal points in a column.
|
| custom = "Custom" | A custom format that is not a part of any category.
|
| date = "Date" | Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operating system. Formats without an asterisk are not affected by operating system settings.
|
| fraction = "Fraction" | Fraction formats display the cell value as a whole number with the remainder rounded to the nearest fraction value.
|
| general = "General" | General format cells have no specific number format.
|
| number = "Number" | Number is used for general display of numbers. Currency and Accounting offer specialized formatting for monetary value.
|
| percentage = "Percentage" | Percentage formats multiply the cell value by 100 and displays the result with a percent symbol.
|
| scientific = "Scientific" | Scientific formats display the cell value as a number between 1 and 10 multiplied by a power of 10.
|
| special = "Special" | Special formats are useful for tracking list and database values.
|
| text = "Text" | Text format cells are treated as text even when a number is in the cell. The cell is displayed exactly as entered.
|
| time = "Time" | Time formats display date and time serial numbers as date values. Time formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified for the operating system. Formats without an asterisk are not affected by operating system settings.
|