Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to have an excel footer that contains the string "&T". My problem is that when I attempt to do this excel automatically changes it to be "&[Time]". Is there anyway to escape the & to make it display &T as plain text?

share|improve this question
Is your string actually "&T" with the quotes, or $T without the quotes? Have you tried it WITH quotes? Have you tried any of Excel's cell formatting options already? – Ƭᴇcʜιᴇ007 Dec 6 '11 at 19:52
My string is without the quotes. If I add the quotes it changes it to "&[Time]" (with the quotes added). What formatting would I change for this footer? – Kellenjb Dec 6 '11 at 19:53
up vote 1 down vote accepted

Can you try one more "&" in your string, so that it is actually "&&T" ? I have a header in a workbook that had the same issue, and I solved it that way.

share|improve this answer
That did it. I should have known to try that. Thank you. – Kellenjb Dec 6 '11 at 20:03

You could also use the "Wingdings 2" font for capital Z.

just type Z and select it, change to wingdings 2 font.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .