- 0 (zero)
- Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero). For example, { = 4 + 5 \# 00.00 } displays "09.00".
- #
- Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a space. For example, { = 9 + 6 \# $### } displays "$ 15".
- x
- Drops digits to the left of the "x" placeholder. If the placeholder is to the right of the decimal point, Word rounds the result to that place. For example:
{ = 111053 + 111439 \# x## } displays "492".
{ = 1/8 \# 0.00x } displays "0.125".
{ = 3/4 \# .x } displays ".8". - . (decimal point)
- Determines the decimal point position. For example, { = SUM(ABOVE) \# $###.00 } displays "$495.47".
Note Use the decimal symbol specified as part of the regional settings in Microsoft Windows Control Panel.
- , (digit grouping symbol)
- Separates a series of three digits. For example, { = NetProfit \# $#,###,### } displays "$2,456,800".
Note Use the digit grouping symbol specified as part of the regional settings in Windows Control Panel.
- - (minus sign)
- Adds a minus sign to a negative result, or adds a space if the result is positive or 0 (zero). For example, { = 10 - 90 \# -## } displays "-80".
- + (plus sign)
- Adds a plus sign to a positive result, a minus sign to a negative result, or a space if the result is 0 (zero). For example, { = 100 - 90 \# +## } displays "+10", and { = 90 - 100 \# +## } displays "-10".
- %, $, *, and so on
- Includes the specified character in the result. For example, { = netprofit \# "##%" } displays "33%".
- "positive; negative"
- Specifies different number formats for positive and negative results. For example, if the bookmark Sales95 is a positive value, the field { Sales95 \# "$#,##0.00;-$#,##0.00" } displays the value with regular formatting
— for example, "$1,245.65". A negative value is displayed with bold formatting and a minus sign — for example, "-$ 345.56". - "positive; negative; zero"
- Specifies different number formats for a positive result, a negative result, and a 0 (zero) result. For example, depending on the value of the Sales95 bookmark, { Sales95 \# "$#,##0.00;($#,##0.00);$0" } displays positive, negative, and 0 (zero) values as follows: $1,245.65, ($ 345.56), $0
- 'text'
- Adds text to the result. Enclose the text in single quotation marks. For example, { = { Price } *8.1% \# "$##0.00 'is sales tax' " } displays "$347.44 is sales tax".
- `numbereditem`
- Displays the number of the preceding item that you numbered by using the Caption command (Insert menu, Reference submenu) or by inserting a SEQ field. Enclose the item identifier, such as "table" or "figure," in grave accents (`). The sequential number is displayed in Arabic numerals. For example, { = SUM(A1:D4) \# "##0.00 'is the total of Table' `table`" } displays "456.34 is the total of Table 2".