View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default ampersand in header

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


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

Any ideas as to why?