Hi courtesio99,

IsNumeric function may can be used.
Note:Assume 3 has been inputted in A1 Cell. Nevertheless the A1 cel
has been formatted as string, IsNumeric function returns TRUE.


Code
-------------------

If IsNumeric([A1]) Then MsgBox "It's a number"

-------------------


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