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

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.
--
Karen

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

Hi Karen,

There is a P with a circle around it in the Webdings font. You can
copy it from the Character Map at StartProgramsAccessories
System ToolsCharacter 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

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

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
--
Gary''s Student - gsnu200721


"Karen" wrote:

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.
--
Karen

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

InsertSymbol doesn't exist in Excel 2000! Must be time to upgrade <g

Regards
Martin



"Gary''s Student" wrote in message
...
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
--
Gary''s Student - gsnu200721


"Karen" wrote:

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.
--
Karen

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

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
--
Gary''s Student - gsnu200721


"MartinW" wrote:

InsertSymbol doesn't exist in Excel 2000! Must be time to upgrade <g

Regards
Martin



"Gary''s Student" wrote in message
...
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
--
Gary''s Student - gsnu200721


"Karen" wrote:

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.
--
Karen