Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you prevent Excel from converting (C) to ©?
How do you prevent Excel from converting (C) to ©?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent text converting to date in copy&pasting tables | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
Prevent cell data from converting to euros | Excel Discussion (Misc queries) | |||
How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
prevent converting numbers with hyphens to dates | Excel Discussion (Misc queries) |