ampersand in header

G

Guest

Enter M&&T in header (using Excel 2003). Print preview displays:
Regular"M&T

Any ideas as to why?
 
C

Chip Pearson

The '&' character is a special control character when used in
heading and footings. For example, &P is used to insert the page
number. To print a literal '&' character, you need to use two
('&&') to indicate that the & character is to be printed, not
used as a control character.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I keep "&" in the header? 2
Ampersand in Header 1
Why does the ampersand symbol disappear when typed in a header? 4
AMPERSAND SIGN IS NOT APPEARING IN THE HEADER,? 3
Problem with Typing "&" in Excel Header section 2
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
using ampersand in the header does not appear 4
Excel Footer Dilemma 1

Top