Prev
EEFormat class |
ExcelExplorer Manual |
Next
String |
 |
(ExcelExplorer 4.0)
Get format index.
integer Index( )
Parameters
- None
Description
Returns format index. Build-in formats not stored in the Excel file, but their indexes still available (see table below).
All indexes from 0 to 163 are reserved for built-in formats.
| Format index |
Excel type |
Format string |
| 0 |
General |
General |
| 1 |
Decimal |
0 |
| 2 |
Decimal |
0.00 |
| 3 |
Decimal |
#,##0 |
| 4 |
Decimal |
#,##0.00 |
| 51 |
Currency |
"$"#,##0_);("$"#,##0) |
| 61 |
Currency |
"$"#,##0_);[Red]("$"#,##0) |
| 71 |
Currency |
"$"#,##0.00_);("$"#,##0.00) |
| 81 |
Currency |
"$"#,##0.00_);[Red]("$"#,##0.00) |
| 9 |
Percent |
0% |
| 10 |
Percent |
0.00% |
| 11 |
Scientific |
0.00E+00 |
| 12 |
Fraction |
# ?/? |
| 13 |
Fraction |
# ??/?? |
| 142 |
Date |
mm/dd/yyyy |
| 15 |
Date |
dd-mmm-yy |
| 16 |
Date |
dd-mmm |
| 17 |
Date |
mmm-yy |
| 18 |
Time |
h:mm AM/PM |
| 19 |
Time |
h:mm:ss AM/PM |
| 20 |
Time |
h:mm |
| 21 |
Time |
h:mm:ss |
| 22 |
Date/Time |
mm/dd/yyyy h:mm |
| 23-26 |
Currency |
If non-US locale used then Excel writes these 4 formats - currency with "$" sign. It equals to formats 5-8 from this table. |
| 27-36 |
Mixed |
These formats used only in special locales (e.g. Japanese date and time) |
| 373 |
Accounting |
_(#,##0_);(#,##0) |
| 383 |
Accounting |
_(#,##0_);[Red](#,##0) |
| 393 |
Accounting |
_(#,##0.00_);(#,##0.00) |
| 403 |
Accounting |
_(#,##0.00_);[Red](#,##0.00) |
| 411 |
Currency |
_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_) |
| 421 |
Currency |
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_) |
| 431 |
Currency |
_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_) |
| 441 |
Currency |
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) |
| 45 |
Time |
mm:ss |
| 46 |
Time |
[h]:mm:ss |
| 47 |
Time |
mm:ss.0 |
| 48 |
Scientific |
##0,0E+0 |
| 49 |
Text |
@ |
| 50-... |
Mixed |
These formats used only in special locales (e.g. Japanese date and time) |
1 - these build-in formats are always written by Excel
because it contains currency symbol of the current locale.
It precedes or follows the value, according to the local settings.
2 - these formats not stored in the file, but Excel displays the value according to the current system locale (month/day/year or day/month/year).
3 - these formats not stored in the file, but Excel displays it using the current system locale.
It can contains currency symbol of the current locale.
See example at ExcelExplorer->FormatsList().
|
