Page 1 of 2 12 LastLast
Results 1 to 15 of 20

Thread: symbols

  1. #1
    New Lounger
    Join Date
    Apr 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    symbols

    I have inserted symbols and special characters in Word, i.e., +-, cents, fractions, but they don't work in Excel. In Special Edition QUE book page 93 says they will work. Any suggestions? I am using Office 2000-no updates.

  2. #2
    susabelle
    Guest

    Re: symbols

    I don't know any direct way of doing it (Excel has NEVER been like Word), but you can copy them and paste them from the character map in windows. Here's the instructions:

    On the Windows Start menu, point to Programs, point to Accessories, and then click Character Map.
    If Character Map is not available, see Windows Help for information about how to install a Windows component. (this is an add-in that can be added wit the Windows CD)

    In the Font box, select the font that contains the character you want.


    In the character grid, click the character you want.


    Click Select, and then click Copy.
    You can select and copy multiple characters.

    Switch to your workbook, and then place the insertion point where you want to paste the character.


    Click Paste .
    If the character looks different from the one you selected, select the character and apply the same font you selected in Character Map.

    Tip Character Map shows the key shortcut you can use in Microsoft Excel to insert the selected character. If the key shortcut includes a number key, press the key you want on the numeric keypad, not on the main keyboard area.

  3. #3
    drichard
    Guest

    Re: symbols

    Try changing the font. After the symbol you can change the font back. A font with a lot of symbols in it is WINGDINGS or MONOTYPE SORTS font. Post if you need further help.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: symbols

    Some characters can be input directly via ascii code using the keyboard :
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    drichard
    Guest

    Re: symbols

    Fonts are designated by the printer. If you have true type fonts loaded then the Symbol and Monotype Sorts fonts should be there. To type in a special symbol '4' is equivalent to a checkmark in Monotype Sorts font. Type your text. "Such as a checkmark 4". Then highlight the 4 and Format, Cells (Font screen will come up) change the font to Monotype Sorts. Then the checkmark will appear. I created sample font lists for these two fonts to learn keystrokes for each font. (See Attached).

  6. #6
    drichard
    Guest

    Re: symbols

    Sorry, the file didn't attach.

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: symbols

    Here's something I'm going to try out:

    Chip Pearsons' "Symbolizer"
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: symbols

    John,
    Did you ever try it out? When I downloaded it, it didn't do anything. Any help?
    Thanks.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: symbols

    It works fine for me. I ran it and it creates a menu option under tools. Chip explains in the link how to make it an addin.

    Steve

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: symbols

    Have yoiu followed the instructions on the website?
    <hr>The Symbolizer program is provided as an xls workbook rather than as an xla add-in. To make it into an add-in, open the xls workbook, and do a Save As, and change the "Save As Type" value to "Microsoft Excel Add-In". Then close all the open workbooks in Excel, and go to the Tools menu, and choose the Add-Ins menu item. In the dialog box that appears, click the Browse button, and navigate to the saved file. This will add it to the list of available add-ins. Scroll down to "Symbolizer" and ensure that the box is checked.<hr>
    When you have done this, there will be a new item in the Tools menu: Symbolize.

  11. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: symbols

    Thanks Steve and Hans. Unfortunately, I am on a workplace network that does not allow us to download "outside" programs without the intervention of our network folks. When they did download the file for me, they didn't include the directions as Has so aptly delineated. Works fine now!
    Thanks again.

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: symbols

    Yes, I have had Symbolizer installed since this thread began, through a couple of Excel versions. And I see you got the installation worked out with help from Steve and Hans. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  13. #13
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: symbols

    Thanks, John. Pretty nifty tool!

  14. #14
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: symbols

    Perhaps one of these documents may help.

    You need to press the + key after the ALT and before the number.

  15. #15
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: symbols

    here's the other document

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •