If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Placing the "&" symbol in an excel header
Since the "&" symbol is used as a programming tool in an
excel header how can I tell excel that it is just a piece of text that I want to show on my header page? |
#2
|
|||
|
|||
Placing the "&" symbol in an excel header
You can put an apostrophe before it like
'& same with '= '+ '=SUM(A1:A3) wrote in message ... Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header page? |
#3
|
|||
|
|||
Placing the "&" symbol in an excel header
In the header and footer, you need two ampersands (&&)
See here http://www.dicks-blog.com/excel/2004...aders_and.html -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Dave R." wrote in message ... You can put an apostrophe before it like '& same with '= '+ '=SUM(A1:A3) wrote in message ... Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header page? |
#4
|
|||
|
|||
Placing the "&" symbol in an excel header
If the OP wants this in a header he needs 2 ampersands,
-- Regards, Peo Sjoblom "Dave R." wrote in message ... You can put an apostrophe before it like '& same with '= '+ '=SUM(A1:A3) wrote in message ... Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header page? |
#5
|
|||
|
|||
Placing the "&" symbol in an excel header
That doesn't seem to work in the header area. The "'"
shows up in the test of the header. For exmaple instead of "Law & Order" appearing in the header "Law ' Order" appears. -----Original Message----- You can put an apostrophe before it like '& same with '= '+ '=SUM(A1:A3) wrote in message ... Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header page? . |
#6
|
|||
|
|||
Placing the "&" symbol in an excel header
Oops sorry 'bout that!
"Dave R." wrote in message ... You can put an apostrophe before it like '& same with '= '+ '=SUM(A1:A3) wrote in message ... Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header page? |
#7
|
|||
|
|||
Placing the "&" symbol in an excel header
Use two && as in....
Lewis && Clarke Gord Dibben Excel MVP On Fri, 30 Apr 2004 08:28:58 -0700, wrote: Since the "&" symbol is used as a programming tool in an excel header how can I tell excel that it is just a piece of text that I want to show on my header page? |
Thread Tools | |
Display Modes | |
|
|