Special characters in titles

E

Elizabeth

I am trying to put "AB&D" in the header of a worksheet but
it always converts the "&D" to the date. I can put it in
a cell but not in the header. I've tried double quotes,
single quotes and backslash, all to no avail. Any ideas?
 
C

Chip Pearson

Elizabeth,

To use an & character in the header or footer, use two of them.
E.g. "AB&&D"


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