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?

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

AT&&T

will display as

AT&T
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John Mirabella" wrote:

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

Double up the ampersand characters; use AT&&T.
--
David Biddulph


"John Mirabella" <John (E-Mail Removed)> wrote in message
news:237F6534-B3C5-4080-8EF1-(E-Mail Removed)...
> 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?