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

Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Disabling &[Time] macro in headers and footers 1
Auto date function in the footer 0
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2
Excel 2007, Headers & Footers question 2
transferring headers and footers 1
Setting up Default Headers/Footers in Excel 3
Add standard header and footer to new worksheet 2

Top