Hi

Try
=IF(ISNUMBER(J1),"YES","NO")

--
Regards

Roger Govier


"Ctech" wrote in
message ...

Hi

Im trying to make this formula in Excel. But it needs some tweeking..

=IF(J1= a number, "YES")

how do I do the number part?


--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread:
http://www.excelforum.com/showthread...hreadid=499349