Disabling the "&[Time]" or "&[T]" in Excel headers and footers


J

John Mirabella

Every time I require an Excel header or footer that has a company name with
"&T" (such as "AT&T" or "BS&T"), the "&T" in the header or footer gets
converted to a HH:MM timestamp when printing out. When I go back to edit the
header or footer, the "&T" has been replaced with "&[Time]". Of course,
Excel Help does not seem to acknowledge that it has a "&[Time]" function or
macro. How does one disable this function?
 
Ad

Advertisements

L

Luke M

Input the ampersand twice, as it is normally an operation character.

AT&&T

will display as

AT&T
 
Ad

Advertisements


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

Top