RE: Excel cell content

Subject: RE: Excel cell content
From: "Patty Ewy" <pewy -at- microsoft -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Tue, 15 Jun 2004 06:47:43 -0700


Andy had "Jones -at- 34 -dot- 15" in a cell and didn't want Excel to treat it as an
e-mail address.

If you precede the text in the cell with an apostrophe ('Jones -at- 34 -dot- 15)
then the apostrophe isn't displayed and the text isn't treated as an
e-mail address. Of course, this assumes that you're just using the cell
for storing text, and that its contents aren't being used in any
formulas or calculations. (If you are, you can probably work around the
apostrophe, but right off the bat it might appear to flummox things.)

Patty
Microsoft Business Solutions

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

SEE THE ALL NEW ROBOHELP X5 IN ACTION: RoboHelp X5 is a giant leap forward
in Help authoring technology, featuring Word 2003 support, Content
Management, Multi-Author support, PDF and XML support and much more! http://www.macromedia.com/go/techwrldemo

COMPONENTONE DOC-TO-HELP 7 PROFESSIONAL: From a single set of Word documents, create online Help and printed documentation. New version offers yearly subscription service, Natural Search, Modular TOC Utility, Image Map Editor, Theme Designer, Context String Editor, plus more. http://www.componentone.com/doctohelp .

---
You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit
http://www.raycomm.com/techwhirl/ for more resources and info.



Previous by Author: Possible Memory Problem? Please help identify!
Next by Author: Adobe FrameMaker for Mac OS X Petition
Previous by Thread: RE: Excel cell content
Next by Thread: Reviewing FrameMaker documents


What this post helpful? Share it with friends and colleagues:


Sponsored Ads