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 - 30 Apr 2006 17:14 GMT
you probably have something written webdings font or something simila
to tha
--
davesexce
Gary''s Student - 30 Apr 2006 19:04 GMT
In consecutive cells enter =CHAR(167) thru CHAR(17)
Format these cells with the Symbol font to see the card types

Signature
Gary''s Student
> 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.
vandenberg p - 30 Apr 2006 19:04 GMT
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 - 30 Apr 2006 19:13 GMT
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
> 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.