how can I use the ampersand in a custom header as the word "and"?

P

pickle77

When I type in an "&" in the center of my custom header, it takes the words
after that sign and moves them into the right cell. I would like to use the
sign rather than the word "and". Is this possible?
 
B

Bernard Liengme

Use two ampersands as in "Fish && Chips"
Only one will display
best wishes
 
T

Tim879

What version of excel are you using. I tried to recreate what you were
talking about it was unsuccessful.

Maybe you could email me your file?
 
P

pickle77

Excel 2003
I could email you the file to play with if you'd like. What's your address?
 
Top