Data Validation - want to use symbols, but list is in orig font

R

richchipper

I want to use the symbols for trademarks in a validation list. I listed the
characters in cells using the "Symbol" font. However, when the list pulls
up, it's in the original font (Arial) so the characters appear differently.
I tried changing the whole spreadsheet to "Symbol" to see if this would
change anything, but the characters are still in the Arial format.

Is there any way to make the list pull in the font for the symbols?
 
T

T. Valko

Not sure what symbols for trademarks you're wanting to use.

The ones I'm familiar with are the superscript TM, the "circle C" and the
"circle R".

Try this...

We'll use cells F1:F3 to hold these symbols and be the source for the drop
down list.

Select cell F1
Goto the menu Insert>Symbol
On the Symbols tab...
Select Font: MS Reference Sans Serif
Character code: 2122 (superscript TM)
From: Unicode (Hex)
Click Insert
Close
Hit Enter to enter the symbol in the cell

Repeat that process for the other characters:

"circle C" = character code 00A9
"circle R" = character code 00AE

Then, as the source for your data validation drop down list use: =$F$1:$F$3
 

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