Class NumberFormats

Namespace

SheetStream.Styles

Assembly

SheetStream.dll

Frequently used Excel number format codes.

public static class NumberFormats

Inheritance

object

NumberFormats

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Fields

Date

ISO-style date.

public const string Date = "yyyy-mm-dd"

Field Value

string

DateTime

ISO-style date and time.

public const string DateTime = "yyyy-mm-dd hh:mm:ss"

Field Value

string

Decimal2

Two decimals with thousands separator.

public const string Decimal2 = "#,##0.00"

Field Value

string

Duration

Elapsed time that can exceed 24 hours.

public const string Duration = "[h]:mm:ss"

Field Value

string

General

Excel's default format.

public const string General = "General"

Field Value

string

Integer

Whole number with thousands separator.

public const string Integer = "#,##0"

Field Value

string

Percent

Percentage with two decimals.

public const string Percent = "0.00%"

Field Value

string

Text

Forces text display; numbers are shown as typed.

public const string Text = "@"

Field Value

string