LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 279
Default Cell interpreted as mailto

I run Excel 2003.
I composed a cell with the value 4.6@3
Excel chose to give that text a color of blue, underline it and
interpret it as a mailto, so that clicking on it causes my email program
to open. I do not want that special action.
I changed color to automatic and removed the underline, but the cell is
still interpreted as a mailto. I know that prefixing a number with a
prime character, causes it to be interpreted as text - where is that
documented? - but '4.6@3 is also interpreted as a mailto.

How do I stop 4.6@3 being interpreted as a mailto?
A reference to a help topic would be best, but I will gladly accept a
heuristic.

I have answered my own question.
The relevant help topic is "Remove a hyperlink" where "Deactivate a
single hyperlink" says "Right-click the hyperlink you want to
deactivate, and then click Remove Hyperlink on the shortcut menu."

I have a supplementary question. How do I stop Excel interpreting cells
as hyperlinks? I found nothing obvious in Tools\Options.

I will repeat the question already asked in passing, above.
Where is the use of prime (') to cause a number to be interpreted as
text documented?

I think there is a general question there. How do I control special
action by Excel on entering a set of characters into a cell?
--
Walter Briscoe
 
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
decimal number interpreted as a date aa Excel Discussion (Misc queries) 5 July 22nd 09 02:01 PM
How do I copy a hyperlink in a mailto: to a new cell in Excell? natboyd6 Excel Discussion (Misc queries) 0 September 30th 08 04:45 PM
Hyperlink mailto - ref cell for mail subject LDUNN1 Excel Worksheet Functions 2 October 25th 06 02:01 PM
excel CSV is interpreted as HTML MikeDb Excel Discussion (Misc queries) 6 December 10th 04 10:35 AM
How can I avoid a BLANK cell being interpreted as a ZERO? matt Excel Programming 4 October 26th 03 08:02 PM


All times are GMT +1. The time now is 05:35 PM.

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"