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

Luke M

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

AT&&T

will display as

AT&T
 

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

Disabling &[Time] macro in headers and footers 1
Excel 2007, Headers & Footers question 2
transferring headers and footers 1
Setting up Default Headers/Footers in Excel 3
Headers and Footers in VBA 4
Including document property values in Excel headers 2
edit the build in headers and footers 2
Printing Headers on only first page and Footers on only last page 5

Top