How do I change fonts in a DV drop down menu
 

I created a Data Validation drop down menu. I am using symbols (specifically
a check mark) from the wingdings font. The data displays the proper symbol
on the spreadsheet however when you open the drop down menu it dispalys the
keyboard charactor (in this case a "P") instead of the symbol. How do I get
the drop down menu to display the symbol and not the letter?

How do I change fonts in a DV drop down menu
 

Are you up for a kludge solution?

This symbol is actually the math symbol for square root. It can "pass" as a
checkmark symbol. At least, with my poor eyesight it looks like a checkmark!
<g

I'm assuming you're using a range of cells as the source for your drop down
list.

Select the cell that currently holds your wingding checkmark.
Delete that symbol
Goto the menu InsertSymbol
On the Symbol tab, in the Font drop down select MS Reference Sans Serif
In the lower right hand corner where it says: From, select Unicode (Hex)
In the Character code box enter: 221A
InsertClose
Then hit Enter

Now your drop down list will contain the actual symbol.

There may be another font that has a real checkmark symbol where this will
work. Just have to find it. There's sooooo many fonts!

--
Biff
Microsoft Excel MVP


"uptight26" wrote in message
...
I created a Data Validation drop down menu. I am using symbols
(specifically
a check mark) from the wingdings font. The data displays the proper
symbol
on the spreadsheet however when you open the drop down menu it dispalys
the
keyboard charactor (in this case a "P") instead of the symbol. How do I
get
the drop down menu to display the symbol and not the letter?