Microsoft KB Archive/31916

Using Quotation Marks in a Number Format PSS ID Number: Q31916 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00

WINDOWS

Summary:

To use a quotation mark in a number format so a number will be displayed as 30&quot;, use a backslash character immediately in front of the quotation mark.

More Information:

To apply the number format, do the following:


 * 1) Select the cell or range of cells to format.
 * 2) Select Number from the Format menu.
 * 3) A dialog box will appear. Press ALT+F.
 * 4) The Format text box will now be highlighted. Enter the number format. For example, to format 30 as 30&quot;, enter the format as follows:

0&quot;

  Press the TAB key to select the OK button.   Press the ENTER key to apply the format. 

Additional reference words: 2.0 2.00 2.01 2.1 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.