View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default formatting cells

Select a Custom Format for your cell range, then enter:

@\@"your_domain_name"

HTH,
Elkar

"crazyj" wrote:

I need to type in e-mail addresses for everyone at work, and we have more
than 1,000. Is there a format I can create that will add the last part of
the e-mail (which is the same for everyone) to what I type? (similar to
typing in #'s and having the dollar sign added)