ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ampersand in header (https://www.excelbanter.com/excel-discussion-misc-queries/70570-ampersand-header.html)

EllenSeitz

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

Any ideas as to why?


Chip Pearson

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?





All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com