# Custom Numeric Formats

Developers can enter custom numeric formats by typing them in directly. For example, one of the standard date formats is "###,###,##0.00". Developers can directly enter other combinations of valid formatting characters, such as "$#,##0" to obtain the desired format.

Here are the valid numeric formatting characters:

Chars | Description |
---|---|

None | Displays the number with no formatting. |

0 | Digit placeholder. Displays a digit or a zero. If the expression has a digit in the position where the zero appears in the format string, display it; otherwise, displays a zero in that position. If the number has fewer digits than there are zeros (on either side of the decimal) in the format expression, displays leading or trailing zeros. If the number has more digits to the right of the decimal separator than there are zeros to the right of the decimal separator in the format expression, rounds the number to as many decimal places as there are zeros. If the number has more digits to the left of the decimal separator than there are zeros to the left of the decimal separator in the format expression, displays the extra digits without modification. |

# | Digit placeholder. Displays a digit or nothing. If the expression has a
digit in the position where the This symbol works like the |

. | Decimal placeholder. The decimal placeholder determines how many digits are
displayed to the left and right of the decimal separator. If the format
expression contains only |

% | Percent placeholder. Multiplies the expression by 100. The percent character
( |

, | Thousand separator. The thousand separator separates thousands from hundreds
within a number that has four or more places to the left of the decimal
separator. Standard use of the thousand separator is specified if the format
contains a thousand separator surrounded by digit placeholders ( For example, you can use the format string Multiple separators in any position other than immediately to the left of the decimal separator or the rightmost position in the string are treated simply as specifying the use of a thousand separator. In some locales, a period is used as a thousand separator. The actual character used as the thousand separator in the formatted output depends on the Number Format recognized by your system. Thus, you should use the comma as the thousand separator in your formats even if you are in a locale that uses a period as a thousand separator. The formatted string will appear in the format correct for the locale. |

E- E+ e- e+ | Scientific format. If the format expression contains at least one digit
placeholder ( |

- + $ ( ) | Literal characters. These characters are displayed exactly as typed in the
format string. To display a character other than one of those listed, precede it
with a backslash ( |

\ | Displays the next character in the format string. To display a character that
has special meaning as a literal character, precede it with a backslash
( Examples of characters that can't be displayed as literal characters are the
date-formatting and time-formatting characters ( |

Visit the MicrosoftCustom Numeric Formats page for more information.

## Comments

0 comments

Please sign in to leave a comment.