Formatting in a list box

[Guest]

I have a range of 5 cells that have symbols (what our company uses to
indicate status) that are generated from a specific font set. When using
that font, a user presses alt+ 4 numbers from the number keypad to generate
the symbol. Lets say I name that range status. Then elsewhere, I generate a
list box that points to that range. When I click on the dropdown arrow, i
see the ascii code and not the symbol, but when I click the ascii character
the appropriate symbol is displayed. (Yes i have the entire sheet set to use
that font) How can I get the drop down to properly display the symbols so
that a user knows which one they are choosing?

 

[Guest]

Roger,

Did you set up the List Boxes? I've used them before, but never set them
up. Could you help?

 

[Guest]

I created the list box using the Data-->Validation-->Allow (selection) List
and then choosing the range of cells (or alternately using a named range).

 

[Guest]

Thanks so much!

I created the list box using the Data-->Validation-->Allow (selection) List
and then choosing the range of cells (or alternately using a named range).