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.
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, or you could have been pressing the alt key and the keys on the numbers key pad which insert symbols, if you goto excels help it will show you the symbols you can get and the key strokes to get it
Last edited by davesexcel; 04-30-2006 at 12:17 PM.
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 <[email protected]> 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" <[email protected]> wrote in message news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks