0
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?
0
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?
1
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.
That did it. I should have known to try that. Thank you. – Kellenjb – 2011-12-06T20:03:13.430
0
You could also use the "Wingdings 2" font for capital Z.
just type Z and select it, change to wingdings 2 font.
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 – 2011-12-06T19:52:14.117My 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 – 2011-12-06T19:53:08.187