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

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?

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

The short answer is no. Data validation list are Arial font.
--
HTH...

Jim Thomlinson


"richchipper" wrote:

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?

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

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 InsertSymbol
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

--
Biff
Microsoft Excel MVP


"richchipper" wrote in message
...
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?