Those look like Unicode characters to me.

In fact, I could do this to put them in a cell:

Option Explicit
Sub testme1()
Dim myCell As Range
Set myCell = ActiveSheet.Range("a1")
myCell.Value = ChrW(8710) & ChrW(9674)
End Sub

and this to examine each character:
Sub testme2()
Dim myCell As Range
Dim iCtr As Long

Set myCell = ActiveSheet.Range("a1")

For iCtr = 1 To Len(myCell.Value)
MsgBox AscW(Mid(myCell.Value, iCtr, 1))
Next iCtr
End Sub




Piranha wrote:

Hi,
I have the Diamond and the triangle ∆ ◊ in my Character
map for Arial font in XPHome.
Thx
Dave

JB Wrote:
The confusing thing is, in the Arial character map the diamond and
triangle
do not exist. The Arial code for these two shapes (using =code(cell
ref)) is
63 and it shows in the Arial map as a square without fill. Am I
missing
something?

"Dave Peterson" wrote:

Unless you change it, the font for the formula bar is Arial. So no
matter what
the cell looks like on the worksheet, it'll appear as Arial in the
formula bar.

And you got lucky that you were using Arial for both the triangle and
the
diamond.

If you really want to see the star, then you could change that option
to show
Wingdings in the formula bar (don't do it--you won't be able to read
anything!)

Tools|Options|General Tab|Standard Font
(Restart excel--you'll be prompted)

If you do play with this, make a note of your original settings so
you can
change them back easily!

JB wrote:

I inherited a worksheet that uses diamond & triangle symbols. These
symbols
display in the cell AND formula bar as a diamond or triangle in
Arial font
and both have code 63. I'd like to add a star (Wingdings 171), but
my star
displays in the cell as a star, but as << in the formula bar. How
can I get
the star to have the same properties as the diamond &
triangle--that is
display as the star symbol in arial font?

--

Dave Peterson


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=373873

--

Dave Peterson