| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
@ sign not to be treated as an email address
I'm using the @ sign and Excel insists on treating it as an email address,
when I don't want it to. How can I turn this off? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
@ sign not to be treated as an email address
The easiest way thing to do is move your mouse over the cell and click the
arrow for the drop down menu on the lightning icon that appears and tell it to stop automatically creating hyperlinks. Or under the tools tab go to auto correct. select the auto format as you type tab and uncheck the box for "Internet and network paths with hyperlinks". "phmanatee" wrote: I'm using the @ sign and Excel insists on treating it as an email address, when I don't want it to. How can I turn this off? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
@ sign not to be treated as an email address
I don't know if this works in all versions, but when I had that similar
problem I placed an apostrophe ( ' ) infront of whatever you have. It works for me, but I'm sure that there is a better answer somewhere floating around on this website. Good luck, MikeC "phmanatee" wrote: I'm using the @ sign and Excel insists on treating it as an email address, when I don't want it to. How can I turn this off? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
@ sign not to be treated as an email address
In Excel 2002 and up you can disable this
ToolsAutoCorrect options See the autoformat as you type tab You can also start with a ' when you start typing Or use Ctrl z after you enter -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "phmanatee" wrote in message ... I'm using the @ sign and Excel insists on treating it as an email address, when I don't want it to. How can I turn this off? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
@ sign not to be treated as an email address
In Excel 2007 :
Office buttton Excel options Proofing Autocorrect options Autoformat as you type tab -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... In Excel 2002 and up you can disable this ToolsAutoCorrect options See the autoformat as you type tab You can also start with a ' when you start typing Or use Ctrl z after you enter -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "phmanatee" wrote in message ... I'm using the @ sign and Excel insists on treating it as an email address, when I don't want it to. How can I turn this off? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
@ sign not to be treated as an email address
On May 21, 4:31 pm, phmanatee
wrote: I'm using the @ sign and Excel insists on treating it as an email address, when I don't want it to. How can I turn this off? put a " ' " in front of the formula/string of text, that usually turns- off any functions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i convert an email address to a web address | Excel Worksheet Functions | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| stop creating email link when @ sign is present | Excel Discussion (Misc queries) | |||
| Shut off email address from linking to email program? | Excel Worksheet Functions | |||
Linear Mode
