Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Enum

ExcelNumberPreset

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
0eef6a5756b9 with working tree changes
Base
Enum
Implements
IComparable ISpanFormattable IFormattable IConvertible
Modifiers
sealed

Common number format presets for convenience. For full control, use a custom format string.

Inheritance

  • Enum
  • ExcelNumberPreset

Usage

Explore 15 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Accepted by parameters 2

Values

public const ExcelNumberPreset General #

General format with no specific pattern.

Value: 0
public const ExcelNumberPreset Integer #

Whole number with thousands separators.

Value: 1
public const ExcelNumberPreset Decimal #

Decimal number with configurable fraction digits.

Value: 2
public const ExcelNumberPreset Percent #

Percentage format.

Value: 3
public const ExcelNumberPreset Currency #

Currency format using culture-specific symbol.

Value: 4
public const ExcelNumberPreset Scientific #

Scientific notation.

Value: 5
public const ExcelNumberPreset DateShort #

Short date format (yyyy-mm-dd).

Value: 6
public const ExcelNumberPreset DateLong #

Long date/time format (yyyy-mm-dd hh:mm).

Value: 7
public const ExcelNumberPreset Time #

Time format (h:mm:ss).

Value: 8
public const ExcelNumberPreset DateTime #

Date and time format (yyyy-mm-dd hh:mm:ss).

Value: 9
public const ExcelNumberPreset DurationHours #

Duration in hours format ([h]:mm:ss).

Value: 10
public const ExcelNumberPreset Text #

Text format.

Value: 11