How do I change fonts in a DV drop down menu

U

uptight26

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?
 
T

T. Valko

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 Insert>Symbol
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
Insert>Close
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!
 

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