Numbers or Text 1

[luceze]

Is there any kind of worksheet function that can tell if the contents of a cell is text or a number. For example, b1=x, b2=3. I would like a formula in a1 that looks at b1 and returns some value depending on whether b1 is a number or text.

Thanks,
Eric
Excel 2000

 

[ETID]

try the isnumber function


example:


=IF(ISNUMBER(A1),"Number","Text&quot

 

[luceze]

Thanks. I knew it was something easy but I couldn't find it in the help file.