Microsoft KB Archive/67476

{| = Excel: Placing Quotation Marks in Number Formats =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q67476

SUMMARY
To have a quotation mark appear in a number format, the backslash (\) character must be used.

For example, to create a format to display 654 as follows

The Number is &quot;654&quot; the following number format should be created in Format Number as follows: &quot;The Number is &quot;\&quot;#\&quot;

MORE INFORMATION
The backslash character tells Excel to display the following character, rather than use it as a command. Normally, the quotation mark is used as a method of containing text strings (for example, &quot;The Number is&quot;).

For more information on number formats, see pages 178 to 182 of the &quot;Microsoft Excel User's Guide&quot; for version 3.0 and pages 305 to 308 of the &quot;Microsoft Excel Reference&quot; manual for version 2.2.
 * }