Special characters in titles

[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?

 

[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