Header/Footer horizontal margins/text positioning

[Guest]

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)

 

[Guest]

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]

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