Excel: Printing an Ampersand in a Header or Footer

 Last reviewed: November 30, 1994
Article ID: Q89627
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY

In order to have an ampersand print in the header or footer of Microsoft Excel it is necessary to enter two ampersands where a single ampersand should appear.

MORE INFORMATION

The ampersand, by default, is used to initiate codes for special formatting in the headers and footers therefore to enter an ampersand in the header or footer it is necessary to enter two.

For example to enter "Johnson & Sons" in the header or footer area of Page Setup it would be necessary to type it as "Johnson && Sons".

There is an additional consideration when you type in certain character strings as well. For example, if the text string "MP&L" is desired in a header or footer, "MP && L" (including the spaces on either side of the ampersand) must be typed in order to get consistent results.

Previous versions of Microsoft Excel also use the ampersand for header or footer formatting codes and require the double ampersand to print a single ampersand. However, the documentation for Microsoft Excel version 4.0 excludes this information.

KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 5.00 4.0 4.00 docerr

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.