Use the ISNUMBER() function within your IF() function.

Like this:

=IF(ISNUMBER(A1),A1,"")

This will result in the value of A1 if it's numeric but blank ("") if
it's not.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=466914