+ Reply to Thread
Results 1 to 3 of 3

Hyperlink not required

  1. #1
    Registered User
    Join Date
    07-23-2016
    Location
    London
    MS-Off Ver
    MIcrosoft 2016
    Posts
    22

    Hyperlink not required

    Hi Folks
    This is a quick post.

    When I input say:

    [email protected] in the cell its reverts to a hyperlink which I dont want. How do I prevent this and I just want to show it as text ONLY?

    Thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Hyperlink not required

    Hi sunshine,

    Here is a very quick answer.

    https://answers.microsoft.com/en-us/...c-68b599b31bf5

    I also believe if you put a single quote in front of a typed in email name it will not hyperlink it.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-23-2016
    Location
    London
    MS-Off Ver
    MIcrosoft 2016
    Posts
    22

    Re: Hyperlink not required

    Thanks for that.

    I think I found a better way. See below:

    On the Excel Ribbon, click the File tab, then click Options.
    Click the Proofing category, and click the AutoCorrect Options button.
    On the AutoFormat As You Type tab, remove the check mark from Internet and network paths with hyperlinks.
    Click OK, twice, to close the dialog boxes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dyanamic Hyperlink required
    By jayarajmarydasan in forum Excel General
    Replies: 3
    Last Post: 04-15-2019, 08:12 AM
  2. [SOLVED] Simple Conditional Formating Help Required - If Blank then Red Bold text required
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2014, 12:23 PM
  3. HELP REQUIRED Macro for Multiple Hyperlink , copy and paste into excel
    By stefanoste in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2014, 01:08 AM
  4. Help required in matching data in required format
    By pravindwd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2013, 09:03 PM
  5. Hyperlink Help Required
    By newbie13 in forum Excel General
    Replies: 1
    Last Post: 05-28-2008, 05:59 AM
  6. Replies: 1
    Last Post: 04-27-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1