Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Putting special characters into Excel...
Hello.
This should be simple. I have a table in Excel and wnat to insert the sum symbol (sigma) into the table. How can I do this? Just like Word has an insert symbol function, how can I insert uncommon symbols into an excel cell. I tried copying from Word and pasting into Excel. This works...however the table that I had, which linked to Word, displayed a ? instead of the sigma symbol. Any ideas much appreciated. Regards Alex |
#2
|
|||
|
|||
I haven't tested this yet, but you might want to try a different font. Times new Roman should have the symbol, but some do not. -- WREFORD ------------------------------------------------------------------------ WREFORD's Profile: http://www.excelforum.com/member.php...o&userid=26594 View this thread: http://www.excelforum.com/showthread...hreadid=399184 |
#3
|
|||
|
|||
You could open CharMap
(Windows start button|run|Charmap) and copy|paste (and format the cell or character with that font). or... Chip Pearson has an addin that may help (if you're using xl2k or lower). http://www.cpearson.com/excel/download.htm (look for Symbolizer and make sure you get the correct version) Alex wrote: Hello. This should be simple. I have a table in Excel and wnat to insert the sum symbol (sigma) into the table. How can I do this? Just like Word has an insert symbol function, how can I insert uncommon symbols into an excel cell. I tried copying from Word and pasting into Excel. This works...however the table that I had, which linked to Word, displayed a ? instead of the sigma symbol. Any ideas much appreciated. Regards Alex -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
special characters (little box) | Excel Discussion (Misc queries) | |||
Is there a size limit for putting a excel webpage online? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions |