+ Reply to Thread
Results 1 to 4 of 4

Header/Footer horizontal margins/text positioning

  1. #1
    akhergert
    Guest

    Header/Footer horizontal margins/text positioning

    Is there a way to set horizontal header/footer margins? Or, to set the color
    of header/footer text? I need to shift a date in the right footer leftwards
    about two spaces for it to align. When I type two spaces (or any number of
    spaces) after the date in the footer, Excel trims them.

    I tried inserting two Chr(32)s (spaces) after the date in VB but they were
    still trimmed (the date is being placed in the footer using "&D" in VB, but I
    have the same issue when I type the spaces directly after the date in the
    footer).

    Also found a couple ASCII characters I didn't have on my machine, and I
    placed one after the two spaces. This succeeded in preserving the two
    spaces, but when I opened the document on another machine the ASCII character
    showed up, so I need another solution.

    Placing the date in the center footer and inserting a bunch of spaces before
    it to shift it rightward is not an option because the page number is in the
    center footer.

    Anyone know a way to shift text leftwards, or to set the color so I can put
    some white characters after the date to 'shift' it over?

  2. #2
    Tom Ogilvy
    Guest

    Re: Header/Footer horizontal margins/text positioning

    try a chr(160) instead of a chr(32)

    --
    Regards,
    Tom Ogilvy


    "akhergert" <akhergert@discussions.microsoft.com> wrote in message
    news:041DA084-CB4A-4505-AE2B-7127C30F2765@microsoft.com...
    > Is there a way to set horizontal header/footer margins? Or, to set the

    color
    > of header/footer text? I need to shift a date in the right footer

    leftwards
    > about two spaces for it to align. When I type two spaces (or any number

    of
    > spaces) after the date in the footer, Excel trims them.
    >
    > I tried inserting two Chr(32)s (spaces) after the date in VB but they were
    > still trimmed (the date is being placed in the footer using "&D" in VB,

    but I
    > have the same issue when I type the spaces directly after the date in the
    > footer).
    >
    > Also found a couple ASCII characters I didn't have on my machine, and I
    > placed one after the two spaces. This succeeded in preserving the two
    > spaces, but when I opened the document on another machine the ASCII

    character
    > showed up, so I need another solution.
    >
    > Placing the date in the center footer and inserting a bunch of spaces

    before
    > it to shift it rightward is not an option because the page number is in

    the
    > center footer.
    >
    > Anyone know a way to shift text leftwards, or to set the color so I can

    put
    > some white characters after the date to 'shift' it over?




  3. #3
    akhergert
    Guest

    Re: Header/Footer horizontal margins/text positioning

    Is 160 a blank character universally? One machine I tried it on still
    printed a box with a gray outline- could just have been the printer though.


    "Tom Ogilvy" wrote:

    > try a chr(160) instead of a chr(32)
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "akhergert" <akhergert@discussions.microsoft.com> wrote in message
    > news:041DA084-CB4A-4505-AE2B-7127C30F2765@microsoft.com...
    > > Is there a way to set horizontal header/footer margins? Or, to set the

    > color
    > > of header/footer text? I need to shift a date in the right footer

    > leftwards
    > > about two spaces for it to align. When I type two spaces (or any number

    > of
    > > spaces) after the date in the footer, Excel trims them.
    > >
    > > I tried inserting two Chr(32)s (spaces) after the date in VB but they were
    > > still trimmed (the date is being placed in the footer using "&D" in VB,

    > but I
    > > have the same issue when I type the spaces directly after the date in the
    > > footer).
    > >
    > > Also found a couple ASCII characters I didn't have on my machine, and I
    > > placed one after the two spaces. This succeeded in preserving the two
    > > spaces, but when I opened the document on another machine the ASCII

    > character
    > > showed up, so I need another solution.
    > >
    > > Placing the date in the center footer and inserting a bunch of spaces

    > before
    > > it to shift it rightward is not an option because the page number is in

    > the
    > > center footer.
    > >
    > > Anyone know a way to shift text leftwards, or to set the color so I can

    > put
    > > some white characters after the date to 'shift' it over?

    >
    >
    >


  4. #4
    Tom Ogilvy
    Guest

    Re: Header/Footer horizontal margins/text positioning

    It is a non-breaking space character commonly used in web pages. Whether
    any fonts use it as something else, I can't say.

    --
    regards,
    Tom Ogilvy


    "akhergert" <akhergert@discussions.microsoft.com> wrote in message
    news:963428CF-C2D1-4918-851A-4E75973C60CA@microsoft.com...
    > Is 160 a blank character universally? One machine I tried it on still
    > printed a box with a gray outline- could just have been the printer

    though.
    >
    >
    > "Tom Ogilvy" wrote:
    >
    > > try a chr(160) instead of a chr(32)
    > >
    > > --
    > > Regards,
    > > Tom Ogilvy
    > >
    > >
    > > "akhergert" <akhergert@discussions.microsoft.com> wrote in message
    > > news:041DA084-CB4A-4505-AE2B-7127C30F2765@microsoft.com...
    > > > Is there a way to set horizontal header/footer margins? Or, to set

    the
    > > color
    > > > of header/footer text? I need to shift a date in the right footer

    > > leftwards
    > > > about two spaces for it to align. When I type two spaces (or any

    number
    > > of
    > > > spaces) after the date in the footer, Excel trims them.
    > > >
    > > > I tried inserting two Chr(32)s (spaces) after the date in VB but they

    were
    > > > still trimmed (the date is being placed in the footer using "&D" in

    VB,
    > > but I
    > > > have the same issue when I type the spaces directly after the date in

    the
    > > > footer).
    > > >
    > > > Also found a couple ASCII characters I didn't have on my machine, and

    I
    > > > placed one after the two spaces. This succeeded in preserving the two
    > > > spaces, but when I opened the document on another machine the ASCII

    > > character
    > > > showed up, so I need another solution.
    > > >
    > > > Placing the date in the center footer and inserting a bunch of spaces

    > > before
    > > > it to shift it rightward is not an option because the page number is

    in
    > > the
    > > > center footer.
    > > >
    > > > Anyone know a way to shift text leftwards, or to set the color so I

    can
    > > put
    > > > some white characters after the date to 'shift' it over?

    > >
    > >
    > >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1