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.

On Tue, 10 Jun 2008 17:39:01 -0700, Grenier
wrote:

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