real number
On Fri, 31 Mar 2006 05:40:16 -0600, kontraa
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
|