View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Disabling the "&[Time]" or "&[T]" in Excel headers and footers

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?