ExcelBanter - Excel Header Formulas

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Header Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/138731-excel-header-formulas.html)

DASaintI8

Excel Header Formulas

Can I stop "&T" in header text from changing to "[&Time]" ?

The automatic change makes "Q&T Tires" become "Q10:48AM Tires" in my header.

Thanks in advance.

Peo Sjoblom

Excel Header Formulas

Use this instead

Q&&T Tires

An extra ampersand tells Excel to use it literally

--
Regards,

Peo Sjoblom

"DASaintI8" wrote in message
...
Can I stop "&T" in header text from changing to "[&Time]" ?

The automatic change makes "Q&T Tires" become "Q10:48AM Tires" in my
header.

Thanks in advance.

EeOr

Excel Header Formulas

Hi there, try: Q&&T Tires

This should give you what you are looking for.

Jon

"DASaintI8" wrote in message
...
Can I stop "&T" in header text from changing to "[&Time]" ?

The automatic change makes "Q&T Tires" become "Q10:48AM Tires" in my
header.

Thanks in advance.

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