Header/Footer horizontal margins/text positioning

[akhergert]

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?

[Tom Ogilvy]

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?

[akhergert]

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?
>
>
>

[Tom Ogilvy]

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?
> >
> >
> >