If not numeric then

[#1]

Hey everyone,

do you know how the syntax of the condition:

If the expression is text/ not numeric then ....

Thanks for any help!

[CELAMBARASAN]

Hi ,

     Try using Alt method.

          Like Alt(exp1,exp2)

     If exp1 is not numeric then it check for exp2.

Celambarasan

[swuehl · Accepted solution]

Check out the logical functions

istext()

or

isnum()