Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,090
Default Using "@" unrelated to email address

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
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
Split email address into seperat columns mg_sv_r Excel Worksheet Functions 1 January 9th 06 11:56 AM
How to format a cell as email address Steve Freides Excel Discussion (Misc queries) 4 September 21st 05 08:38 PM
stop automatically making email address lily Excel Discussion (Misc queries) 1 March 23rd 05 04:53 AM
how do I make make my hyperlinks show the email address they are . Dustin Excel Discussion (Misc queries) 0 January 13th 05 01:39 AM
Remove Email address header Mark Excel Discussion (Misc queries) 2 December 3rd 04 10:27 PM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"