Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default How do you prevent Excel from converting (C) to ©?

How do you prevent Excel from converting (C) to ©?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do you prevent Excel from converting (C) to ©?

Delete that item from your AutoCorrect Options.

ToolsAutocorrect


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 16:51:03 -0800, Louis Zaffino
wrote:

How do you prevent Excel from converting (C) to ©?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do you prevent Excel from converting (C) to©?

In xl2003 menus:

Tools|autocorrect options|autocorrect tab
Look for (C) and delete that entry.

You could also hit Edit|Undo (or Ctrl-z) to change it back as soon as excel
"helps" out.

Louis Zaffino wrote:

How do you prevent Excel from converting (C) to ©?


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default How do you prevent Excel from converting (C) to ©?

Tools-AutoCorrect

You will see there that there is a definition replace (C) with ©

If you change that to replace (C) with (C), it will prevent the ©, However,
I think this is a global setting so that it will always ignor © from that
point forward and you will have to insert that characer as a symbal. Not sure
if this is what you actually want to do???

Does this help????

Kindest Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Louis Zaffino" wrote:

How do you prevent Excel from converting (C) to ©?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default How do you prevent Excel from converting (C) to ©?

Gord:

Thank you. It was a little thing but it was bugging me. Is it hard to add
the copyright icon back to Autocorrect? Don't bother responding, I should at
least attempt it myself before asking. Thank you again.

"Gord Dibben" wrote:

Delete that item from your AutoCorrect Options.

ToolsAutocorrect


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 16:51:03 -0800, Louis Zaffino
wrote:

How do you prevent Excel from converting (C) to ©?





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default How do you prevent Excel from converting (C) to ©?

If you open word, type ctrl-alt-C the copy right symbol will appear. Copy
that from word and paste it into

Replace (C) with (Press Ctrl V to Paste ©) in the with column
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Louis Zaffino" wrote:

Gord:

Thank you. It was a little thing but it was bugging me. Is it hard to add
the copyright icon back to Autocorrect? Don't bother responding, I should at
least attempt it myself before asking. Thank you again.

"Gord Dibben" wrote:

Delete that item from your AutoCorrect Options.

ToolsAutocorrect


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 16:51:03 -0800, Louis Zaffino
wrote:

How do you prevent Excel from converting (C) to ©?



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do you prevent Excel from converting (C) to©?

If you're afraid to delete it, just change the "from" string to something that
you'll never see in real life:

Have (C)asdfasdf corrected to the copyright symbol (for example).


Louis Zaffino wrote:

Gord:

Thank you. It was a little thing but it was bugging me. Is it hard to add
the copyright icon back to Autocorrect? Don't bother responding, I should at
least attempt it myself before asking. Thank you again.

"Gord Dibben" wrote:

Delete that item from your AutoCorrect Options.

ToolsAutocorrect


Gord Dibben MS Excel MVP

On Mon, 5 Jan 2009 16:51:03 -0800, Louis Zaffino
wrote:

How do you prevent Excel from converting (C) to ©?




--

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
Prevent text converting to date in copy&pasting tables patrickj Excel Discussion (Misc queries) 0 January 23rd 08 01:38 AM
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH ROB Excel Discussion (Misc queries) 2 April 2nd 07 01:13 PM
Prevent cell data from converting to euros mcdonobr Excel Discussion (Misc queries) 1 April 22nd 06 08:40 PM
How to prevent Excel converting imported fractions into dates Phil A in the UK Excel Discussion (Misc queries) 6 March 28th 06 08:03 AM
prevent converting numbers with hyphens to dates Mike Excel Discussion (Misc queries) 5 January 27th 06 08:41 PM


All times are GMT +1. The time now is 08:49 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"