Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Alex
 
Posts: n/a
Default 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   Report Post  
WREFORD
 
Posts: n/a
Default


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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
special characters (little box) YuChieh Excel Discussion (Misc queries) 9 June 14th 05 01:41 PM
Is there a size limit for putting a excel webpage online? [email protected] Excel Discussion (Misc queries) 0 March 3rd 05 02:57 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Find/Replace carriage return & line feed characters in Excel. Mary Cullen Excel Worksheet Functions 1 January 4th 05 07:39 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"