Symbols in footers - Excel 2003

[Guest3731]

Hi - I'm trying to put a legend or symbol key in the footer of a
spreadsheet. I would like to use various Wingding symbols - stars,
etc. - but when I try to paste into a footer, all I get is a - mark.
Am I doing something wrong or is this impossible? Is there a
workaround? It's Excel 2003.

Thank you!

 

[Dave Peterson]

I bet you'll have to change the font for just the characters you want to be
symbols.

Select those symbols, click the A button, and change the font.

Then do a print preview to see if it worked.

 

[Gary''s Student]

Very easy...Don't paste:

File > Page Setup... > Header/Footer > Custom Header
and then TYPE the material into one of the three section.

Then hi-light what you have just typed and touch the A-button (first on the
left) and from the resulting dialog box select the Wingdings font.

 

[Guest3731]

Very easy...Don't paste:

File > Page Setup... > Header/Footer > Custom Header
and then TYPE the material into one of the three section.

Then hi-light what you have just typed and touch the A-button (first on the
left) and from the resulting dialog box select the Wingdings font.

That works perfectly. Unfortunately it's a bit of a long footer, so
I'm getting a message about the 255 character limit, even though I'm
swapping the Wingdings 1-for-1 with some Ascii characters. Special
character sets must "take up extra room" or something.

Thanks for the help!

 

[Guest3731]

That works perfectly. Unfortunately it's a bit of a long footer, so
I'm getting a message about the 255 character limit, even though I'm
swapping the Wingdings 1-for-1 with some Ascii characters. Special
character sets must "take up extra room" or something.

Thanks for the help!

Oddly, I tried just creating one single "star" symbol in Wingding font
in a footer, and I got the same message (that there is a 255-character
limit for footnotes).

This would seem to imply that it is impossible to use Wingding font in
a footer - can anyone suggest a workaround for this?

Thanks much -

 

[Dave Peterson]

Excel includes the font string specification in the length of the footer.

Record a macro when you pretend to change the footer and you'll see something
like:

..CenterHeader = "&20qwer&""Wingdings,Regular""Y&""Arial,Regular""asdf"

(my test header)

And if I do this:
MsgBox Len(ActiveSheet.PageSetup.CenterHeader)

I get 48 -- even though I only have 9 visible characters.