Special Characters in Headers and Footers

[Guest]

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?

 

[Bernard Liengme]

Use two in a row as "ABC"&&[Date]
best wishes

 

[Dave Peterson]

Use && to show one ampersand.

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?

 

[Guest]

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]).|:>)

 

[Gord Dibben]

To get an ampersand to show up, insert two ampersands

Gord && LPS returns Gord & LPS

For other characters you can use Insert>Symbol 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

 

[Myrna Larson]

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.

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]).|:>)

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?