close

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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537593In consecutive cells enter =CHAR(167) thru CHAR(17)
Format these cells with the Symbol font to see the card types
--
Gary''s Studentquot;etpconsciousquot; wrote:

gt; i was working a formula in excel and i mistakenly hit a key which caused a
gt; spade ( a la diamonds, hearts, clubs, spades) to appear. Can someone tell me
gt; 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:

support.microsoft.com/kb/q195041/

(look towards the bottom of the page)

Pieter Vandenberg

etpconscious gt; 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.
www.mvps.org/dmcritchie/rexx/htm/fonts.htm
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) lt;gringt;.

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

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()