Headers and Footers

G

Guest

I'm using Excel vers. 2002. Why is it that the "&" (ampersand) doesn't show
up in headers and footers? I've been having to actually type out the word
"and". Is there a way to make the "&" show up?
 
D

Dante Gagne [MSFT]

The & character is a special character in Excel that says "The thing that
comes after the & is special". Instead of just saying &, say &&. Excel will
realize that you're trying to use a & symbol, not making an & formula.

Hope that helps!

--
Dante Gagne
Software Design Engineer/Test
Developer Division
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
 
G

Guest

Thank you very much. It works!!

Dante Gagne said:
The & character is a special character in Excel that says "The thing that
comes after the & is special". Instead of just saying &, say &&. Excel will
realize that you're trying to use a & symbol, not making an & formula.

Hope that helps!

--
Dante Gagne
Software Design Engineer/Test
Developer Division
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
Click to expand...
 

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

Headers and Footers size 2
Is it possible to set headers and footers to show in normal page . 4
Headers & Footers _auto update info from a cell in the worksheet 4
Protecting Headers and Footers!! 2
Headers and Footers 3
why aren't my headers and footers visible on the pages? 1
How can I change the predefined headers and footers in Excel? 2
Help with Headers and Footers 1

Top