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