Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Excel.NumberFormatCategory enum
- Package:
- excel
Represents a category of number formats.
Remarks
Used by
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. |
Office Add-ins
Feedback
Was this page helpful?