Special Char in footer ?

G

Grenier

Using excel as a report and want to use footer as a legend.
using 'wingdings 2' char like chr(190) for a square and followed by a
description in Arial . chr(196) for a circle and followed by description in
arial ...

Anybody know the trick ?

Merci !
JFG.
 
R

Ron Rosenfeld

Using excel as a report and want to use footer as a legend.
using 'wingdings 2' char like chr(190) for a square and followed by a
description in Arial . chr(196) for a circle and followed by description in
arial ...

Anybody know the trick ?

Merci !
JFG.

This works in Excel 2007 - I don't have any other version to try it on.

Type in on of the footer boxes:

<alt-190> description

By <alt-190> I mean to hold down the <alt> key and, while holding it down,
type 190 on the NUMERIC KEYPAD (not on the numbers above the keyboard). After
typing the 190, release the <alt> key.

Then, with the cursor, select the symbol that appeared when you typed
<alt-190>. Click on the font button (looks like an "A"), and select the
wingdings 2 font.
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top