Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KKilpatrick
 
Posts: n/a
Default Excel should have the same Insert Symbol feature as Word.

There is currently no easy way to insert a symbol such as a degree sign in
Excel. It would be much easier to have a function like Insert Symbol from
Word to do this as one is typing rather than cut & paste from Word or using
the Character Map from Windows (outside of Excel).
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

MS added it in xl2002.

But Chip Pearson has a couple of versions (depending on what you're running) at:
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

KKilpatrick wrote:

There is currently no easy way to insert a symbol such as a degree sign in
Excel. It would be much easier to have a function like Insert Symbol from
Word to do this as one is typing rather than cut & paste from Word or using
the Character Map from Windows (outside of Excel).


--

Dave Peterson
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

The Character Map can be brought up in Excel.

Not as nice as Chip's add-in or the InsertSymbol with 2002 and beyond.

Sub CharMap()
Dim taskID As Variant
On Error Resume Next
taskID = Shell("start charmap.exe")
If Err < 0 Then _
MsgBox "CHARMAP.EXE is not installed on your machine."
End Sub

Assign to a button or shortcut key.


Gord Dibben Excel MVP

On Wed, 13 Apr 2005 16:12:21 -0500, Dave Peterson
wrote:

MS added it in xl2002.

But Chip Pearson has a couple of versions (depending on what you're running) at:
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

KKilpatrick wrote:

There is currently no easy way to insert a symbol such as a degree sign in
Excel. It would be much easier to have a function like Insert Symbol from
Word to do this as one is typing rather than cut & paste from Word or using
the Character Map from Windows (outside of Excel).


  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

And if you want the same effect, but without a macro:

flying window key - r (to show the windows start button|run dialog)
type
charmap
and hit enter.




Gord Dibben wrote:

The Character Map can be brought up in Excel.

Not as nice as Chip's add-in or the InsertSymbol with 2002 and beyond.

Sub CharMap()
Dim taskID As Variant
On Error Resume Next
taskID = Shell("start charmap.exe")
If Err < 0 Then _
MsgBox "CHARMAP.EXE is not installed on your machine."
End Sub

Assign to a button or shortcut key.

Gord Dibben Excel MVP

On Wed, 13 Apr 2005 16:12:21 -0500, Dave Peterson
wrote:

MS added it in xl2002.

But Chip Pearson has a couple of versions (depending on what you're running) at:
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

KKilpatrick wrote:

There is currently no easy way to insert a symbol such as a degree sign in
Excel. It would be much easier to have a function like Insert Symbol from
Word to do this as one is typing rather than cut & paste from Word or using
the Character Map from Windows (outside of Excel).


--

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
Cannot insert a row in Excel spreadsheet fredhep Excel Worksheet Functions 3 August 16th 05 02:10 AM
Why can't I insert a Combo Box in Excel? mpatters Excel Discussion (Misc queries) 1 April 6th 05 11:07 PM
Excel document properties insert into a cell Mark Excel Discussion (Misc queries) 3 December 16th 04 03:05 PM
Can I insert digital signatures into an Excel cell? DrewAtNucorUtah Excel Discussion (Misc queries) 1 December 15th 04 07:00 PM
Insert symbol menu Stan Excel Discussion (Misc queries) 4 December 2nd 04 01:03 AM


All times are GMT +1. The time now is 11:20 AM.

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"