ExcelBanter - Excel Header - Auto Format troubles

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

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

- - Excel Header - Auto Format troubles (https://www.excelbanter.com/excel-discussion-misc-queries/245007-excel-header-auto-format-troubles.html)

Kurtboard

Excel Header - Auto Format troubles

I am trying to type the phrase "PM&E Subdivision ..." into my excel sheet
header. However after I click away from the header all text, following the
&E becomes double underlined and the &E disappears. I have tried turning off
all of the auto-complete and formatting functionality, but I am missing
something as I can not prevent the header from applying the change. Any
advice would be greatly appreciated.

Kurt

SixBowls

Excel Header - Auto Format troubles

Type in "PM&&E Subdivision ..."

"Kurtboard" wrote:

I am trying to type the phrase "PM&E Subdivision ..." into my excel sheet
header. However after I click away from the header all text, following the
&E becomes double underlined and the &E disappears. I have tried turning off
all of the auto-complete and formatting functionality, but I am missing
something as I can not prevent the header from applying the change. Any
advice would be greatly appreciated.

Kurt

All times are GMT +1. The time now is 06:32 AM.