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

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.

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