Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 21st 05, 02:18 PM
Steve Freides
 
Posts: n/a
Default How to format a cell as email address

Someone sent me a spreadsheet with a column for email addresses. Only
some of the addresses are clickable links and I thought I'd do everyone
a service and fix the cells that aren't formatted properly and sent the
spreadsheet back out again. (It's a team list for one of my kids' sports
teams.)

But, when I go into format, I see lots of things like text, number,
currency, special - but no email. How does one do this?

I'm using Excel Office 2003, SP1, running on XP/Pro, SP2, with all the
latest updates to both.

Thanks in advance.

-S-
http://www.kbnj.com




  #2   Report Post  
Old September 21st 05, 03:54 PM
Casey
 
Posts: n/a
Default


Steve Freides,

One way is to select the cell you want to place an active e-mail
address and go to InsertHyperlink in the dialog box select e-mail
address (lower left hand corner in Excel 2002) type in your email
address in the line provided.

Normally, when I type in a line of text in a cell that looks like an
email address Excel recognizes it as such and makes it a hyperlink. But
that may be an option setting that I'm unaware of and just happen to
have set correctly on my machine by luck.

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=469512

  #3   Report Post  
Old September 21st 05, 04:10 PM
bigwheel
 
Posts: n/a
Default

e-mail addresses should be hyperlinks, so select the cell containing the
non-clickable text, then click on the Hyperlink tool. The Inser Hyperlink
dialog will appear so then click E-mail Address and fill in the details under
the e-mail address input space (harder to describe than actually doing it!!)

"Steve Freides" wrote:

Someone sent me a spreadsheet with a column for email addresses. Only
some of the addresses are clickable links and I thought I'd do everyone
a service and fix the cells that aren't formatted properly and sent the
spreadsheet back out again. (It's a team list for one of my kids' sports
teams.)

But, when I go into format, I see lots of things like text, number,
currency, special - but no email. How does one do this?

I'm using Excel Office 2003, SP1, running on XP/Pro, SP2, with all the
latest updates to both.

Thanks in advance.

-S-
http://www.kbnj.com




  #4   Report Post  
Old September 21st 05, 04:44 PM
Steve Freides
 
Posts: n/a
Default

Thank you both.

-S-
http://www.kbnj.com


"bigwheel" wrote in message
news
e-mail addresses should be hyperlinks, so select the cell containing
the
non-clickable text, then click on the Hyperlink tool. The Inser
Hyperlink
dialog will appear so then click E-mail Address and fill in the
details under
the e-mail address input space (harder to describe than actually doing
it!!)

"Steve Freides" wrote:

Someone sent me a spreadsheet with a column for email addresses.
Only
some of the addresses are clickable links and I thought I'd do
everyone
a service and fix the cells that aren't formatted properly and sent
the
spreadsheet back out again. (It's a team list for one of my kids'
sports
teams.)

But, when I go into format, I see lots of things like text, number,
currency, special - but no email. How does one do this?

I'm using Excel Office 2003, SP1, running on XP/Pro, SP2, with all
the
latest updates to both.

Thanks in advance.

-S-
http://www.kbnj.com






  #5   Report Post  
Old September 21st 05, 08:38 PM
Michael
 
Posts: n/a
Default

Steve, you can also select the cell, press F2 and Enter and it will create
the hyperlink for you.
--
Sincerely, Michael Colvin


"Steve Freides" wrote:

Thank you both.

-S-
http://www.kbnj.com


"bigwheel" wrote in message
news
e-mail addresses should be hyperlinks, so select the cell containing
the
non-clickable text, then click on the Hyperlink tool. The Inser
Hyperlink
dialog will appear so then click E-mail Address and fill in the
details under
the e-mail address input space (harder to describe than actually doing
it!!)

"Steve Freides" wrote:

Someone sent me a spreadsheet with a column for email addresses.
Only
some of the addresses are clickable links and I thought I'd do
everyone
a service and fix the cells that aren't formatted properly and sent
the
spreadsheet back out again. (It's a team list for one of my kids'
sports
teams.)

But, when I go into format, I see lots of things like text, number,
currency, special - but no email. How does one do this?

I'm using Excel Office 2003, SP1, running on XP/Pro, SP2, with all
the
latest updates to both.

Thanks in advance.

-S-
http://www.kbnj.com









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
Concatenating a cell address nebb Excel Worksheet Functions 3 July 16th 05 10:38 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
How do I find the contents of a cell using the "ADDRESS" function. sweeney Excel Worksheet Functions 2 April 5th 05 03:23 AM
Format a Cell in Excel as an IP address field willvi Excel Discussion (Misc queries) 1 March 2nd 05 07:25 PM


All times are GMT +1. The time now is 05:45 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017