Hi!

OK, you can't convert TEXT numbers to NUMERIC numbers by changing the
format. Did you try this:

Copy an empty cell
Select the range Y1:Y5809
EditPaste SpecialAdd

Biff

"vect98" wrote in
message ...

Hi i tried that =ISNUMBER(AJ200) thing and it worked ok for the AJ
column, but when I did it for the Y column it returns false even though
i made sure the column was in Number format (no decimals) so i'm not
sure why its returnging false, thus im thinking this is why ur original
formula isnt working.

Thanks : )


--
vect98
------------------------------------------------------------------------
vect98's Profile:
http://www.excelforum.com/member.php...o&userid=26365
View this thread: http://www.excelforum.com/showthread...hreadid=469366