BuiltInNumberFormats

Returns a currency format with no decimals and standard positive/negative patterns (e.g. en-US: $#,##0_);($#,##0)).

Returns a currency format with no decimals using red for negative values (e.g. en-US: $#,##0_);Red).

Returns a currency format with two decimals and standard positive/negative patterns (e.g. en-US: $#,##0.00_);($#,##0.00)).

Returns a currency format with two decimals using red for negative values (e.g. en-US: $#,##0.00_);Red).

Generates a Currency number format string. Example format in en-US culture: (*#,##0);(*(#,##0);(* "-");(@_).

Generates a Currency number format string. Example format in en-US culture: ($*#,##0);($*(#,##0);($* "-");(@_).

Generates a Currency number format string. Example format in en-US culture: (*#,##0.00);(*(#,##0.00);(*"-"??);(@_).

Generates a Currency number format string. Example format in en-US culture: ($*#,##0.00);($*(#,##0.00);($*"-"??);(@_).

Generates a Date number format with day and month. Example format in en-US culture: d-mmm.

Generates a Date number format with day, month and year. Example format in en-US culture: m/d/yyyy.

Generates a Date number format with day, month and year. Example format in en-US culture: d-mmm-yy.

Returns built in format with the specified id.

Generates a Fraction number format for up to one digit. Example format in en-US culture: # ?/?.

Generates a Fraction number format for up to two digit. Example format in en-US culture: # ??/??.

Returns the General number format string for the current culture (e.g. en-US: General).

Generates a Time number format with hours and minutes. Example format in en-US culture: h:mm.

Generates a Time number format with hours, minutes and AM/PM. Example format in en-US culture: h:mm AM/PM.

Generates a Time number format with hours, minutes and seconds. Example format in en-US culture: h:mm:ss.

Generates a Time number format with hours, minutes, seconds and AM/PM. Example format in en-US culture: h:mm:ss AM/PM.

Generates a Date number format with month and year. Example format in en-US culture: mmm-yy.

Returns the basic integer number format (e.g. en-US: 0).

Returns a number format with two decimal places and no thousands separator (e.g. en-US: 0.00).

Returns an integer number format including thousands separators (e.g. en-US: #,##0).

Returns a number format with two decimal places and thousands separators (e.g. en-US: #,##0.00).

Generates a Currency number format string with no decimal places, a thousand separator, and positive and negative format pattern and alignment. Example format in en-US culture: #,##0_);(#,##0).

Generates a Currency number format string with no decimal places, a thousand separator, and positive and negative format with red digits patterns and alignment. Example format in en-US culture: #,##0_);Red.

Generates a Currency number format string with two decimal places, a thousand separator, and positive and negative format pattern and alignment. Example format in en-US culture: #,##0.00_);(#,##0.00).

Generates a Currency number format string with two decimal places, a thousand separator, and positive and negative format with red digits patterns and alignment. Example format in en-US culture: #,##0.00_);Red.

Returns a percent format with no decimal places (e.g. en-US: 0%).

Returns a percent format with two decimal places (e.g. en-US: 0.00%).

Generates a cuture dependent Scientific number format string. Example format in en-US culture: 0.00E+00.

Generates a culture dependent Scientific number format string. Example format in en-US culture: ##0.0E+0.

Generates a Date number format for short date. Example format in en-US culture: m/d/yyyy.

Generates a Time number format with short date, hours and minutes. Example format in en-US culture: m/d/yyyy h:mm.