Formatting in Excel

  • Thread starter Thread starter DGAZACCT
  • Start date Start date
D

DGAZACCT

How can I type my e-mail address so that it is not a fuctioning link?
 
Prefix with a apostrophe as

'(e-mail address removed)

If this post helps click Yes
 
Hi,

1. One method is to format the range as Text first and then entering the
addresses.

2. Choose Tools, AutoCorrect Options, AutoFormat As You Type tab, uncheck
Internet and network paths with hyperlinks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub countm in filter 4
Obtain days in a given year 11
Paste and Link 3
How to Format a Nested Function (Bold) 2
Hide rows function 4
Text to Hyperlink 2
Hide Values when data has not been entered into a cell. 2
disable autosorting in Pivot Table Excel 2000 2

Back
Top