Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / July 2008



Tip: Looking for answers? Try searching our database.

another validation question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Harvey Waxman - 10 Jul 2008 00:26 GMT
I want to prevent entry into a cell, O3 unless another cell E3 has
something in it.

The validation I entered in O3 is  =ISNONTEXT(E3)  but when I check
validation later I see:   =ISNONTEXT(E3)e

Where does the "e" come from?

Excel OfficeX  Leopard
Bob Greenblatt - 10 Jul 2008 12:34 GMT
On 7/9/08 7:26 PM, in article
hnwaxman-854990.19262009072008@news.microsoft.com, "Harvey Waxman"
<hnwaxman@gmail.com> wrote:

> I want to prevent entry into a cell, O3 unless another cell E3 has
> something in it.
[quoted text clipped - 5 lines]
>
> Excel OfficeX  Leopard
You really will get better responses if you only post once.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.