ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Header with & (https://www.excelbanter.com/excel-discussion-misc-queries/2123-header.html)

Carla Bradley

Header with &
 
I have Excel 2003 and need to put our company name LG&E ENERGY in the header
but Excel must think the & is some kind of format, because it changes it to
LG ENERGY (removes the &E and double underlines the word ENERGY). What can I
do to tell it to stop!!! Thanks in advance for your help!!

Carla

Peo Sjoblom

Just use 2 ampersands, i.e.

LG&&E ENERGY

Regards,

Peo Sjoblom

"Carla Bradley" wrote:

I have Excel 2003 and need to put our company name LG&E ENERGY in the header
but Excel must think the & is some kind of format, because it changes it to
LG ENERGY (removes the &E and double underlines the word ENERGY). What can I
do to tell it to stop!!! Thanks in advance for your help!!

Carla



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com