using a function to insert symbol

G

Guest

Hi ppl.
I've been using functions to make symbols from the Monotype Sorts font
appear. I've always been using the CHAR(186) way of doing it, but it's not
working anymore.
I've set the cell to use Monotype Sorts font, and typed =Char(186),
expecting to see a 5 on a black circle, but nothing shows up. 186 is the
character code shown in insert-> symbols.
Hope someone can help me on this!
Thanks
 
G

Gord Dibben

Try Alt + 0186

Note: type the 0186 on the NumPad

I don't have the Monotype Sorts font installed, but Wingdings and Alt + 0144
gives me a 5 on a black circle.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Replace List Formatting 1
Displaying symbol from inside a calculation 3
Some fonts not available under "insert symbol" 2
Button to insert Symbol 2 2
Symbol "font" - not Unicode compliant, how to Search/Replace? 2
Restricted symbol selection 5
Using Symbols in Drop Down Lists 2
Inserting mulitpul Text and a Tab Symbol into a cell 0

Top