I've never seen this symbol before

[Guest]

i was working a formula in excel and i mistakenly hit a key which caused a
spade ( a la diamonds, hearts, clubs, spades) to appear. Can someone tell me
what this represents and how i managed to makee this sign appear.

 

[davesexcel]

you probably have something written webdings font or something simila
to tha

 

[Guest]

In consecutive cells enter =CHAR(167) thru CHAR(17)
Format these cells with the Symbol font to see the card types

 

[vandenberg p]

Hello:

There are lots of these kinds of symbols floating around. What they
kinds depends on the fonts you have installed. As an example I have
WP IconicSymbolsA installed. If I choose that as the font
and type ALt-0205 (on the keypad, not keyboard) the spade will appear.

To see what you have installed use the windows utility: charmap.exe

It should be in windows/system32 directory. Here is a link describing
it:

http://support.microsoft.com/kb/q195041/

(look towards the bottom of the page)

Pieter Vandenberg

: i was working a formula in excel and i mistakenly hit a key which caused a
: spade ( a la diamonds, hearts, clubs, spades) to appear. Can someone tell me
: what this represents and how i managed to makee this sign appear.

 

[David McRitchie]

Can't imagine how you could do it with one or two keys.
If you were in the Symbol font AND you entered Alt+0169
you would get a spade symbol.
http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm

With Excel 2002 and up you can use the Insert menu , then Symbol ...,
then select font and character -- also not an inadvertent simply key
combination thing.

If you have turned on some accessibility options there might be other
ways. Or maybe you have a special keyboard layout for playing
board games (solitaire) <grin>.