How can I insert "&" in Header & Footer?

G

Guest

I'm using Excel 2003.
I've tried to incorporate "&" in the Header & Footer but without success.
I've also tried cut and paste "&" from symbol but it seems it cannot be
pasted in "Custom the Header & Footer".
Hope somebody can answer my question! Thanks!
 
W

William

Use 2 "&" for the footer to show one.

--


XL2003
Regards

William
(e-mail address removed)
 
C

Chip Pearson

The & character is a special control character in headers and
footers. To put an & in the header or footer, use &&.


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



message
news:D[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

Header and Footer 3
Format Header Excel 2007 1
How do I make a single header/footer common across all worksheets? 1
Header and Footer margins 1
How can I keep "&" in the header? 2
Copy of Header-Footer in Excel 3
How to save a custom made header&footer 3
File name in the footer/header 2

Top