Ask Experts Questions for FREE Help !
Ask
    RickJ's Avatar
    RickJ Posts: 7,762, Reputation: 864
    Uber Member
    		  
    #1

    Mar 30, 2007, 05:15 AM
    Excel: How to NOT have email addresses "auto link"
    When I enter an email address in a cell, it becomes a mailto link.

    How can I turn this off?

    (I want to leave it on for entered url's though)

    Thanks!
    NeedKarma's Avatar
    NeedKarma Posts: 10,635, Reputation: 1706
    Uber Member
    		  
    #2

    Mar 30, 2007, 05:26 AM
    Put an apostrophe as the first character of the mailto text

    Ex: 'mailto:[email protected]

    Excel strips out the apostrophe and you end up with text only.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Fan Blower not working in "ON" or "AUTO" in heat or AC [ 13 Answers ]

Got home from the Brewer game this afternoon and noticed the house was warm(78). Outside was 91. I checked the T-stat and it was set correct. Noticed the air vents weren't blowing anything. Went outside and the condenser and fan was running fine. Then I went downstairs to the furnace unit to see...

A/C or Heat does not work w/thermostat set "on" or "auto". [ 22 Answers ]

A/C or Heat doesn't work in "on" or "auto". Fan will not come on at the "on" position either. I changed the batteries in the thermostat. I also read somewhere to disconnect the "Y" and hold it to the "R" on the thermostat for two minutes. That will tell me if the thermostat is the problem. ...

Blower runs on "ON", but not on "Auto" [ 3 Answers ]

Hello All, I have a Goodman COMBINATION HEATING AND COOLING OUTDOOR UNITS PG/PGX SERIES (100K BTU). It failed to warm the space. The fan would not run on “ON” or “Auto” mode. Upon investigating, there is no power to the unit due to 25 amps fuses blown. Replaced with new fuses. Power was...

Heater blows cold when "On", not at all on "Auto" [ 1 Answers ]

Our gas heater is 7 years old, and has worked fine in the two years we've rented here. This winter though, we can't get it to work consistently. When on "Auto", it doesn't turn on at all, no matter what temperature we select, and when we turn the fan to "On", it simply blows cold air. It...

View more questions Search