Symbol in Excel 1

[sern]

Hi. I wish to insert some symbols into my Excel like smile face, a tick, etc. How can I do that?

 

[tav1035]

sern,
You can always create them in word and copy/paste to excel or use webdings, wingdings, etc. font.
tav

 

[tav1035]

sern,
Also here is good little add in for symbols

http://www.cpearson.com/excel/chars.htm

Although I don't see a smiley face.
tav

 

[Chrismenzies]

Sern

Another way to insert symbols into Excel is to open the Character Map (Start, Programs, Accessories, System Tools, Character Map), selct a symbol, click copy and then return to your Excel sheet and click paste.

I hope this helps.

CRML

 

[chriswoo]

What version of Office are you using ? - The character map is available in Office XP (Insert - Symbol). It's very useful !

 

[MeGustaXL]

Yet another way is to set the cell font to Symbol or Wingdings and type the appropriate text, e.g. a Smiley "" is "J" in Wingdings and a tick is Alt-0252 on the Numeric Keypad.

HTH


Chris

Varium et mutabile semper Excel

 

[tav1035]

chriswoo,
Good point Chris, but Excel 2000 doesn't have symbols. So I assumed Sern was on 2000.
Your right Excel 2002 does has the symbol insert.
tav

 

[sern]

thanks all. i have tried using chris method and it works. thanks for all the tips.