PDA

View Full Version : how to check a given input is a String



sathishesb
01-08-2011, 08:44 PM
Hi Guys,

I am reading a value from cell A1, i need check whether the value in the cell is String or integer..?

Help me plzzzz.:help

Sean.DiSanti
01-08-2011, 08:57 PM
you can use IsNumeric()

Aussiebear
01-08-2011, 08:58 PM
=IF(ISTEXT(A1),"text","number")

sathishesb
01-08-2011, 11:07 PM
Thanks !!:clap: