Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xl Headers and Footers always use 3/4 inch side margins??? | New Users to Excel | |||
Losing my headers and footers when I copy the file | Excel Discussion (Misc queries) | |||
Better support for dynamic content within headers and footers | Excel Discussion (Misc queries) | |||
Headers / footers in Excel | Excel Discussion (Misc queries) | |||
In Excel, can I copy Headers and Footers between Worksheets? | Excel Worksheet Functions |