-
Notifications
You must be signed in to change notification settings - Fork 63
/
excel.numberformatcategory.yml
116 lines (100 loc) · 4.75 KB
/
excel.numberformatcategory.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
### YamlMime:TSEnum
name: Excel.NumberFormatCategory
uid: 'excel!Excel.NumberFormatCategory:enum'
package: excel!
fullName: Excel.NumberFormatCategory
summary: Represents a category of number formats.
remarks: '\[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
fields:
- name: accounting
uid: 'excel!Excel.NumberFormatCategory.accounting:member'
package: excel!
summary: |-
Accounting formats line up the currency symbols and decimal points in a column.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Accounting"'
- name: currency
uid: 'excel!Excel.NumberFormatCategory.currency:member'
package: excel!
summary: |-
Currency formats are used for general monetary values. Use Accounting formats to align decimal points in a column.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Currency"'
- name: custom
uid: 'excel!Excel.NumberFormatCategory.custom:member'
package: excel!
summary: |-
A custom format that is not a part of any category.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Custom"'
- name: date
uid: 'excel!Excel.NumberFormatCategory.date:member'
package: excel!
summary: >-
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.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Date"'
- name: fraction
uid: 'excel!Excel.NumberFormatCategory.fraction:member'
package: excel!
summary: >-
Fraction formats display the cell value as a whole number with the remainder rounded to the nearest fraction
value.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Fraction"'
- name: general
uid: 'excel!Excel.NumberFormatCategory.general:member'
package: excel!
summary: |-
General format cells have no specific number format.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"General"'
- name: number
uid: 'excel!Excel.NumberFormatCategory.number:member'
package: excel!
summary: >-
Number is used for general display of numbers. Currency and Accounting offer specialized formatting for monetary
value.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Number"'
- name: percentage
uid: 'excel!Excel.NumberFormatCategory.percentage:member'
package: excel!
summary: |-
Percentage formats multiply the cell value by 100 and displays the result with a percent symbol.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Percentage"'
- name: scientific
uid: 'excel!Excel.NumberFormatCategory.scientific:member'
package: excel!
summary: |-
Scientific formats display the cell value as a number between 1 and 10 multiplied by a power of 10.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Scientific"'
- name: special
uid: 'excel!Excel.NumberFormatCategory.special:member'
package: excel!
summary: |-
Special formats are useful for tracking list and database values.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Special"'
- name: text
uid: 'excel!Excel.NumberFormatCategory.text:member'
package: excel!
summary: |-
Text format cells are treated as text even when a number is in the cell. The cell is displayed exactly as entered.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Text"'
- name: time
uid: 'excel!Excel.NumberFormatCategory.time:member'
package: excel!
summary: >-
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.
* \[ [API set: ExcelApi 1.12](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Time"'