Special Characters in Headers and Footers
 

Using Excel 2000 in a Win 200o O/S, is there any way special characters such
as the ampersand (&) can be displayed in a header and footer?
--
LPS

Use two in a row as "ABC"&&[Date]
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LPS" wrote in message
...
Using Excel 2000 in a Win 200o O/S, is there any way special characters
such
as the ampersand (&) can be displayed in a header and footer?
--
LPS

Use && to show one ampersand.



LPS wrote:

Using Excel 2000 in a Win 200o O/S, is there any way special characters such
as the ampersand (&) can be displayed in a header and footer?
--
LPS

--

Dave Peterson

If you know the correct Unicode/ASCII keystrokes or copy from another source
(i.e., Character Map), yes. I am not sure that the ampersand is allowed since
that character is used by Excel as part of the code syntax (i.e.,
&[Page]).|:)

"LPS" wrote:

Using Excel 2000 in a Win 200o O/S, is there any way special characters such
as the ampersand (&) can be displayed in a header and footer?
--
LPS

To get an ampersand to show up, insert two ampersands

Gord && LPS returns Gord & LPS

For other characters you can use InsertSymbol or ALT + ascii number

ALT + 0040 followed by ALT + 0041 will return ()

Use the numpad at right side to enter the numbers.


Gord Dibben Excel MVP


On Fri, 25 Feb 2005 08:03:08 -0800, LPS wrote:

Using Excel 2000 in a Win 200o O/S, is there any way special characters such
as the ampersand (&) can be displayed in a header and footer?

You can include an ampersand, using the methods that others have mentioned,
but not they way you desribe. It would still be interpreted as a special
character, not an ampersand.

On Fri, 25 Feb 2005 10:03:51 -0800, "CyberTaz"
wrote:

If you know the correct Unicode/ASCII keystrokes or copy from another source
(i.e., Character Map), yes. I am not sure that the ampersand is allowed since
that character is used by Excel as part of the code syntax (i.e.,
&[Page]).|:)

"LPS" wrote:

Using Excel 2000 in a Win 200o O/S, is there any way special characters
such
as the ampersand (&) can be displayed in a header and footer?
--
LPS