How do I get an "&" in a footer

DJM1216 · May 6th, 2002, 03:13 PM

I'm trying to put an & in a footer of a spreadsheet, but it does not recognize it as a value.

In fact I'm writing "... & T..." and it picks it up as "& (Time)" and inserts the time!

How do I fix this, if possible?

lenze · May 6th, 2002, 03:15 PM

type &&

DJM1216 · May 7th, 2002, 09:35 AM

Thanks, that did it!

Mark W. · May 7th, 2002, 09:48 AM

BTW, a search for "&" in Help would have directed you to the "Create custom headers and footers" topic which includes the tip...

"To include a single ampersand (&) within the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 03:13 PM	#1
DJM1216 Board Regular Join Date: Apr 2002 Location: Delray Beach, FL Posts: 77	I'm trying to put an & in a footer of a spreadsheet, but it does not recognize it as a value. In fact I'm writing "... & T..." and it picks it up as "& (Time)" and inserts the time! How do I fix this, if possible?

May 6th, 2002, 03:15 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	type &&

May 7th, 2002, 09:35 AM	#3
DJM1216 Board Regular Join Date: Apr 2002 Location: Delray Beach, FL Posts: 77	Thanks, that did it!

May 7th, 2002, 09:48 AM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	BTW, a search for "&" in Help would have directed you to the "Create custom headers and footers" topic which includes the tip... "To include a single ampersand (&) within the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services."