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.

you probably have something written webdings font or something similar
to that


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537593

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


"etpconscious" wrote:

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.

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

etpconscious wrote:
: 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.

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"etpconscious" wrote in message ...
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.