Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2006

Tip: Looking for answers? Try searching our database.

I've never seen this symbol before

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
etpconscious - 30 Apr 2006 16:57 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.