MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Checking Datatype


Posted by Bill Mahoney on February 15, 2002 9:10 AM

Hello, how can i through code check if a cell contains a number or text? Thanks for any help.

Regards,
Bill Mahoney
New York, NY


Posted by Mark W. on February 15, 2002 9:11 AM

Use the ISTEXT or ISNUMBER worksheet function