close

For reasons not entirely obvious, Office will not allow the use of an
ampersand (amp;) in an Excel custom header in XP.

Why not?

Even with a preceding apostrophe, it disappears without a trace on the
finished product and the print preview with even the empty space black holed
as well.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc


Jack Bacchus Wrote:
gt; For reasons not entirely obvious, Office will not allow the use of an
gt; ampersand (amp;) in an Excel custom header in XP.
gt;
gt; Why not?
gt;
gt; Even with a preceding apostrophe, it disappears without a trace on the
gt; finished product and the print preview with even the empty space black
gt; holed
gt; as well.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the
gt; quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and
gt; then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; tinyurl.com/l3w5tHi Jack,
I believe you have to put an ampersand on each side of the one you
want.
IE:
Hi amp;amp;amp; Hi Again

Result will be --gt; Hi amp; Hi Again--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=540110Use two of them:

ATamp;amp;T

The amp; is used in a few variables amp;Page, amp;pages, ... and needs to be doubled up
if you want to see just one.

Jack Bacchus wrote:
gt;
gt; For reasons not entirely obvious, Office will not allow the use of an
gt; ampersand (amp;) in an Excel custom header in XP.
gt;
gt; Why not?
gt;
gt; Even with a preceding apostrophe, it disappears without a trace on the
gt; finished product and the print preview with even the empty space black holed
gt; as well.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson


Dave Peterson Wrote:
gt; Use two of them:
gt;
gt; ATamp;amp;T
gt;
gt; The amp; is used in a few variables amp;Page, amp;pages, ... and needs to be
gt; doubled up
gt; if you want to see just one.
gt;
gt; Jack Bacchus wrote:
gt; gt;
gt; gt; For reasons not entirely obvious, Office will not allow the use of
gt; an
gt; gt; ampersand (amp;) in an Excel custom header in XP.
gt; gt;
gt; gt; Why not?
gt; gt;
gt; gt; Even with a preceding apostrophe, it disappears without a trace on
gt; the
gt; gt; finished product and the print preview with even the empty space
gt; black holed
gt; gt; as well.
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to
gt; the
gt; gt; suggestions with the most votes. To vote for this suggestion, click
gt; the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button,
gt; follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and
gt; then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; tinyurl.com/l3w5t
gt;
gt; --
gt;
gt; Dave PetersonHi Dave P,
You are so correct. I have an extra one in my response.
Dave H--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=540110

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()