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.
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.
you can use IsNumeric()
=IF(ISTEXT(A1),"text","number")
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Thanks !!