ExcelBanter - How do I stop "&T" in AT&T from displaying time in Excel footer?

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - How do I stop "&T" in AT&T from displaying time in Excel footer? (https://www.excelbanter.com/setting-up-configuration-excel/140879-how-do-i-stop-t-t-displaying-time-excel-footer.html)

M. Harper

How do I stop "&T" in AT&T from displaying time in Excel footer?

I'm trying to add a footer to a spreadsheet with an AT&T proprietary
statement, but it keeps changing AT&T to AT and the time of day. How do I
prevent &T from displaying time and instead get it to display actual &T?

Dave Peterson

How do I stop "&T" in AT&T from displaying time in Excel footer?

Double up on that ampersand
AT&&T

M. Harper wrote:

I'm trying to add a footer to a spreadsheet with an AT&T proprietary
statement, but it keeps changing AT&T to AT and the time of day. How do I
prevent &T from displaying time and instead get it to display actual &T?

--

Dave Peterson

Barb Reinhardt

How do I stop "&T" in AT&T from displaying time in Excel footer?

I initially tried something that was far more complicated.

Try entering it as AT&&T.

"M. Harper" wrote:

I'm trying to add a footer to a spreadsheet with an AT&T proprietary
statement, but it keeps changing AT&T to AT and the time of day. How do I
prevent &T from displaying time and instead get it to display actual &T?

All times are GMT +1. The time now is 10:15 PM.