Edit

Excel.NumberFormatCategory enum

  • Reference
Package:
excel

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.