Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Location
    Knoxville, Tennessee, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ampersand not printing (Excel 2002 (10.4302.4219) SP-2)

    When I go to view header and footer and attempt to create a custom header and try to enter an ampersand by pressing Shift 7 -- it shows up in the header window but when I hit okay it does not appear in the page setup preview and thus it does not print! It seems every other character will work but this one! What's up with that? Any thoughts or suggestions? <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Ampersand not printing (Excel 2002 (10.4302.4219) SP-2)

    The ampersand is used to insert special codes into headers and footers. To display an ampersand, you must double it: A&P will display as A1 (&P being the page number), while A&&P will display as A&P.

  3. #3
    New Lounger
    Join Date
    Apr 2003
    Location
    Knoxville, Tennessee, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ampersand not printing (Excel 2002 (10.4302.4219) SP-2)

    Thanks Hans. It was what I needed and I learned something new today .... So the whole day is now not a loss <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •