| | Product Information Help and How-to Training Templates Related Products and Technologies Support and Feedback Technical Resources Additional Resources | Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Numeric Picture (\#) field switch
Specifies the display of a numeric result. This switch is called a "picture" switch because you use symbols to represent the format of the field result (field results: Text or graphics inserted in a document when Microsoft Word carries out a field's instructions. When you print the document or hide field codes, the field results replace the field codes.). For example, the switch \# $#,##0.00 in { = SUM(ABOVE) \# $#,##0.00 } displays a result such as "$4,455.70." If the result of a field is not a number, this switch has no effect. Note Quotation marks are not required around simple numeric pictures that do not include spaces— for example, { MarchSales \# $#,##0.00 }. For more complex numeric pictures and those that include text or spaces, enclose the numeric picture in quotation marks, as shown in the following picture item examples. Microsoft Word adds quotation marks to numeric picture switches if you insert a field by using the Field command (Insert menu) or the Formula command (Table menu). Combine the following picture items to build a numeric picture switch.  Picture items
- 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 (bookmark: A location or selection of text in a file that you name for reference purposes. Bookmarks identify a location within your file that you can later refer or link to.) 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".
|
United States
Email this link
Printer-Friendly Version
Share
Hide All
