How do I change fonts in a DV drop down menu

  • Thread starter Thread starter uptight26
  • Start date Start date
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?
 
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!
 
Back
Top