|
| 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
April 30th, 2004, 04:28 PM
|
|||
|
|||
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
April 30th, 2004, 04:34 PM
|
|||
|
|||
|
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
April 30th, 2004, 04:49 PM
|
|||
|
|||
|
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
April 30th, 2004, 04:50 PM
|
|||
|
|||
|
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
April 30th, 2004, 04:50 PM
|
|||
|
|||
|
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
April 30th, 2004, 04:55 PM
|
|||
|
|||
|
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
April 30th, 2004, 06:26 PM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
