Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using a function to insert symbol
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using a function to insert symbol
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 On Sun, 30 Sep 2007 09:39:01 -0700, jenn wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert a symbol into a function cell | Excel Worksheet Functions | |||
CAN'T INSERT SYMBOL? | Excel Worksheet Functions | |||
Insert symbol | Excel Discussion (Misc queries) | |||
insert symbol | Excel Worksheet Functions | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |