software

please help...

i need to control if a value in a cell is real number greater then 0.
The problem is that excel threads date as a number too...thanx--
kontraa
------------------------------------------------------------------------
kontraa's Profile: www.excelforum.com/member.php...oamp;userid=33028
View this thread: www.excelforum.com/showthread...hreadid=528497
'RIGHT(TEXT(D21,quot;dd mmm yyyyquot;),4)

if your date is in d21 this will return the text number 2006, say...

you could then apply an IF statement to this--
robert111
------------------------------------------------------------------------
robert111's Profile: www.excelforum.com/member.php...oamp;userid=31996
View this thread: www.excelforum.com/showthread...hreadid=528497On Fri, 31 Mar 2006 05:40:16 -0600, kontraa
gt; wrote:

gt;
gt;please help...
gt;
gt;i need to control if a value in a cell is real number greater then 0.
gt;The problem is that excel threads date as a number too...thanx

Since Excel stores dates as serial numbers, one way of determining if the cell
contains a date is to see if the cell is formatted as a date.

e.g:

=LEFT(CELL(quot;formatquot;,A1),1)=quot;Dquot;

will be TRUE if the cell is formatted as a date.

So maybe something like:

=AND(LEFT(CELL(quot;formatquot;,A1),1)lt;gt;quot;Dquot;,COUNTIF(A1,quot;gt;0 quot;))--ron


just perfect...
thanx a lot...--
kontraa
------------------------------------------------------------------------
kontraa's Profile: www.excelforum.com/member.php...oamp;userid=33028
View this thread: www.excelforum.com/showthread...hreadid=528497On Mon, 3 Apr 2006 02:08:26 -0500, kontraa
gt; wrote:

gt;
gt;just perfect...
gt;thanx a lot...

Glad to help.
--ron