Symbol | Description |
0 | Digit placeholder - pads the number with zeros. This symbol ensures that a specified number of digits appears on each side of the decimal point. For example, if the format is 0.000, the value .987 would be displayed as 0.987. If the format is 0.0000, the value .987 would be displayed as 0.9870. If a number has more digits to the right of the decimal point than the number of 0s specified in the format, the number in the cell is rounded. For example if the format is 0.00, the value .987 would be displayed as 0.99. |
? | Digit placeholder - leaves a space for insignificant zeros but does not display them. This symbol follows the same rules as those for the "0" symbol except that space is left for insiginificant zeros on ether side of the decimal point. This placeholder align numbers on the decimal places. For example 0.34 and 12.45 would line up on the decimal point if both were formatted with 0.?? |
# | Digit placeholder - does not display any extra zeros. This symbol works like 0 except that extra zeros do not appear if the number has fewer digits on either side of the decimal point than #s specified in the format. This symbol shows Excel where to display commas or other separarting symbols. The format #,### for example displays a comma after every third digit to the left of the decimal place. |
. | Decimal point placeholder. This symbol determines how many digits (0 or #) appear to the right or left of the decimal point. If the format contains only #s to the left of this symbol, Excel begins numbers smaller than 1 with a decimal point. To avoid this, use 0 as the first digit placeholder to the left of the decimal point instead of #. If you want Excel to include commas and display at least one digit to the left of the decimal point in all cases specify the format as #,##0 |
% | Percentage Indicator - value is multiplied by 100 and a percentage sign is added to the end. |
/ | Fraction format character. This symbol displays the fractional part of a number in a nondecimal format. The number of digit placeholders that surround this character determines the accuracy of the display. For example, the decimal fraction 0.269 when formatted as #?/? is displayed as 1/4 but when formatted with #???/??? is displayed as 46/171 |
, (comma) | Thousand separator - A comma followed by a placeholder scales the number by 1000. If the format contains a comma surrounded by #s, os or ?s Excel uses commas to separate hundreds from thousands, thousands from millions etc. In addition the comma acts as a rounding and scaling agent. Use one comma at the end of a format to tell Excel to round a number and display is in thousands; two commas tell Excel to round to the nearest million. For example the format #,###,###, rounds 4567890 to 4,568 (thousands) and the format #,###,###,, rounds the same number to 5 (millions). |