how do I create a symbol which can be used in excel

K

Karen

how do I create a symbol which can be used in excel? I want a P with a circle
around it. I have saved this in microsoft picture manager, and can insert it
as a picture, but it does not stay in the cell, if I make changes to the
sheet. Hope this makes sense.
 
M

MartinW

Hi Karen,

There is a P with a circle around it in the Webdings font. You can
copy it from the Character Map at Start>Programs>Accessories>
System Tools>Character Map.

You will need to change your font in that cell to Webdings or if
there is other text in that cell you can change the font for just that
character in the Formula Bar.

Not exactly user friendly, but gets the desired result.

HTH
Martin
 
G

Gary''s Student

Select an empty cell and:

Insert > Symbol...

Pick Arial Unicode MS from the Font dropdown
Pick Unicode(hex) from the from dropdown
enter 2117 in the Character code field
 
M

MartinW

Insert>Symbol doesn't exist in Excel 2000! Must be time to upgrade <g>

Regards
Martin
 
G

Gary''s Student

Interesting...

Will this tiny piece of VBA work on 2000??:

Sub circle_p()
With Selection.Font
.Name = "Arial Unicode MS"
.Size = 14
End With
Selection.HorizontalAlignment = xlCenter
Selection.Value = ChrW(8471)
End Sub
 
Top