How do I get rid of the copyright symbol?

Discussion in 'Microsoft Excel Discussion' started by ultra_xcyter, Jun 30, 2005.

  1. ultra_xcyter

    ultra_xcyter Guest

    I am trying to enter "(c)" into a cell and everytime I do that, Excel
    automatically converts it to the copyright symbol, which I don't want.
    I've tried formatting the cell to text, general, etc. but that doesn't
    work.

    Is there a way to enter "(c)" without it automatically being converted
    to the copyright symbol?

    Thank you in advice for any advice/tips.


    --
    ultra_xcyter
    ------------------------------------------------------------------------
    ultra_xcyter's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9946
    View this thread: http://www.excelforum.com/showthread.php?threadid=383518
     
    ultra_xcyter, Jun 30, 2005
    #1
    1. Advertisements

  2. ultra_xcyter

    swatsp0p Guest

    You need to modify the AutoCorrect setting. From Tools>Options
    |Spelling, click "Auto Correct Options..."

    Scroll down to find the (c) and edit it to [c] and click OK.

    now, (c) will remain unchange, and you call the copyright symbol by
    entering [c]

    Good Luck

    Bruce


    --
    swatsp0p


    ------------------------------------------------------------------------
    swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
    View this thread: http://www.excelforum.com/showthread.php?threadid=383518
     
    swatsp0p, Jun 30, 2005
    #2
    1. Advertisements

  3. ultra_xcyter

    doltish Guest

    doltish, Jun 30, 2005
    #3
  4. ultra_xcyter

    ultra_xcyter Guest

    ultra_xcyter, Jun 30, 2005
    #4
  5. ultra_xcyter

    swatsp0p Guest

    Ultra: I'm glad you found a solution. Thanks for the feedback, it i
    always appreciated.

    Doltish: I tried your tip, but for me the ' didn't do anything and m
    [c] still returned the copyright symbol. Hmmmm..... I don't know...
    must be missing something.... I tried changing [c] back to (c) in th
    AutoCorrect option to no avail. '(c) still brought up the symbol.

    Bruc

    --
    swatsp0

    -----------------------------------------------------------------------
    swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1510
    View this thread: http://www.excelforum.com/showthread.php?threadid=38351
     
    swatsp0p, Jun 30, 2005
    #5
  6. Alternatively:
    -Type (c) + space (entering the space invokes auto-correct and changes
    your entry to the copyright symbol)
    -Ctrl+Z (undo last action: i.e., the autocorrect. Your entry is
    restored.)
    -Finally, press Enter
    --
    George Nicholson

    Remove 'Junk' from return address.



    "ultra_xcyter" <>
    wrote in message
    news:...
    >
    > Doltish & Swatsp0p: Both your suggestions worked great! Thank you very
    > much for your help. No more headaches for me! Or at least until next
    > time.
    >
    >
    > --
    > ultra_xcyter
    > ------------------------------------------------------------------------
    > ultra_xcyter's Profile:
    > http://www.excelforum.com/member.php?action=getinfo&userid=9946
    > View this thread: http://www.excelforum.com/showthread.php?threadid=383518
    >
     
    George Nicholson, Jun 30, 2005
    #6
  7. ultra_xcyter

    swatsp0p Guest

    swatsp0p, Jun 30, 2005
    #7
  8. ultra_xcyter

    Donald Gudehus

    Joined:
    Nov 4, 2008
    Messages:
    1
    Likes Received:
    0
    Thanks for the tip. Under Tools/AutoCorrect... I simply unchecked all 4 boxes. That way I get exactly what I type, rather than unexpected results. Sometimes big brother doesn't know best.
     
    Donald Gudehus, Nov 4, 2008
    #8
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brad Rench

    get rid of macro option at startup

    Brad Rench, Sep 20, 2003, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    228
    Brad Rench
    Sep 21, 2003
  2. David Lariscy

    get a copyright symbol when I want (c)

    David Lariscy, Jan 11, 2004, in forum: Microsoft Excel Discussion
    Replies:
    5
    Views:
    322
    underhill
    Jan 12, 2004
  3. danceexcel66

    vba copyright protection

    danceexcel66, Jun 29, 2004, in forum: Microsoft Excel Discussion
    Replies:
    5
    Views:
    1,731
    JE McGimpsey
    Jul 14, 2004
  4. danceexcel66

    vba copyright protection

    danceexcel66, Jun 29, 2004, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    256
    danceexcel66
    Jun 29, 2004
  5. Han

    Get Rid Of The First Symbol

    Han, Sep 2, 2010, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    267
    Pete_UK
    Sep 3, 2010
Loading...

Share This Page