Dude,

Thanks again for your help. I pretty much figured that alignment must not
be an adjustable property within headers or footers. Since this is the
case, and my users can't make them adjust manually, I'm not going to spend a
lot of time trying to make them adjust by using padding. Once again thanks
for the reply.

Joel

"theDude" wrote in
message ...

Hi Joel,

Essentially, you're 'hosed' trying to justify text in each section of
the footer in Excel 2000. As you experienced, by adding a format code
within a footer section that doesn't match the sections' alignment, the
text appears in the footer section corresponding to the format code
used:

Format code "&L" (Left-align) moves text to the Left footer 'section'
Format code "&C" (Center-align) moves text to the Center footer
'section'
Format code "&R" (Right-align) moves text to the Right footer
'section'

It won't justify text within a footer section (contrary to what the
Help info leads you to believe). Maybe in newer versions it may...As
an alternative, you may be able to 'pad' the text w/leading or trailing
spaces in a footer section to get it positioned where you want it.

Hope this helps,
theDude


--
theDude
------------------------------------------------------------------------
theDude's Profile:
http://www.excelforum.com/member.php...o&userid=16550
View this thread: http://www.excelforum.com/showthread...hreadid=382626