Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Florine
Doing what David and Gary suggest results in a global setting to not apply a hyperlink when @ is entered. This will apply to any usage of the @ symbol anywhere in your file and in any other file. If this is what you want, then do that. But you can achieve the same thing on a local basis by preceding your entry with an apostrophe, like '. HTH Otto "David Biddulph" wrote in message ... "Florine" wrote in message ... When using Excel (Office 2000) worksheets to track my stocks, I use the "@" symbol to mean "at" (like 500 @ 56.30). Instead the cell auto-formats it as a formula (=) and tries to make an email address out of it (with little blue underlined letters) and then tries to put me online. No matter how I try to format the cell it is ignored. After a struggle I can trick it but there must be a way to remove this auto cell conversion from a formula to a regular cell format. Please help. Tools/ AutoCorrect options/ AutoFormat as you type: Uncheck the one about internet & network paths being turned to hyperlinks -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Split email address into seperat columns | Excel Worksheet Functions | |||
How to format a cell as email address | Excel Discussion (Misc queries) | |||
stop automatically making email address | Excel Discussion (Misc queries) | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
Remove Email address header | Excel Discussion (Misc queries) |