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
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
'RIGHT(TEXT(D21,"dd mmm yyyy"),4)
if your date is in d21 this will return the text number 2006, say...
you could then apply an IF statement to this
On Fri, 31 Mar 2006 05:40:16 -0600, kontraa
<[email protected]> wrote:
>
>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
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("format",A1),1)="D"
will be TRUE if the cell is formatted as a date.
So maybe something like:
=AND(LEFT(CELL("format",A1),1)<>"D",COUNTIF(A1,">0"))
--ron
just perfect...
thanx a lot...
On Mon, 3 Apr 2006 02:08:26 -0500, kontraa
<[email protected]> wrote:
>
>just perfect...
>thanx a lot...
Glad to help.
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks