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