Symbols
Posted by Jane Stanley on November 16, 2001 12:36 PM
How do you use sybmols for text cells (like the degree symbol or not equal to symbol) in Excel? It is so easy in Word....
Posted by giacomo on November 16, 2001 1:12 PM
Use Tools|Autocorrect and add the symbols you want to use into your autocorrect list. For example when you type (c) excel automatically changes it to the copyright symbol. You can do the same for the symbols you're looking for.
Posted by Jane on November 16, 2001 1:41 PM
How do you enter the symbol you want to use into the Autocorrect field? I tried to copy and paste it from word, but it just turned into a blank box... Thanks for your help.
Posted by giacomo on November 16, 2001 1:59 PM
There's an application called "Character Map" it should be under Start|Programs|Accessories you can use it to copy a special character and place it into the autocorrect field.
giacomo
Posted by Ben O. on November 16, 2001 3:01 PM
A useful thing to do is to paste this code into your personal macro workbook, which launches Character Map:
Private Sub CharMap()
Dim RetVal
RetVal = Shell("C:\Windows\CharMap.EXE", 1)
End Sub
You can assign the code to a button on your toolbar to always have character map handy. Then you can easily copy and paste symbols into your spreadsheets.
-Ben O.
