Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Cincinnati Ohio USA
    Posts
    139
    Thanks
    0
    Thanked 1 Time in 1 Post
    The attached file was created with a custom top header and I can't find why it won't print or previw the same as it is created. In the box used to enter the text of the header I have an "&" between the 1 and the 2. It does not show up in the preview or the hard copy. Why? Thanks
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    371
    Thanked 1,457 Times in 1,326 Posts
    Paul,

    Since the & is used to denote special fields in the header/footer you need to use a && to get a single & to print.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Cincinnati Ohio USA
    Posts
    139
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks for the prompt response. Now I WIll add "special fields" to the list of many things I don't know about Excel.
    Paul

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    371
    Thanked 1,457 Times in 1,326 Posts
    Paul,

    They're not all that special it's things like &[Date] for the current date and &[Page] for the current page number, etc.
    When you go int the custom header and select the icons for Date, Page, Time, etc you'll see these codes appear.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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