Hi bdcrisp!

Something like:

If IsNumeric(Range("b1")) Then Range("c1") = "You have a number"



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"courtesio99" wrote in
message ...
no.. wat i mean is how to check that a number is entered in cell A1
instead of text.


---
Message posted from http://www.ExcelForum.com/