IF type("tmp")="C" and ALLTRIM(Tmp) = "Runoff Balance Book" ... or
if you care about numbers formatted as text:
IF type("tmp")="C" and not isdigit(alltr(tmp)) and ALLTRIM(Tmp) = "Runoff Balance Book" ...


>Is there a function that will tell me what field type a memory variable is? I have an activeX control getting information from a spreadsheet and the field type is either character or numeric. I need to know what type it is.
>
>Here is the line that captures the data
>
>Tmp = oXL.ActiveSheet.Cells(TmpSVRow,1).VALUE
>
>I am doing an IF statement and I need it to be a character field. Here is the if statement beginning. I have few lines that are numeric.
>
>IF ALLTRIM(Tmp) = "Runoff Balance Book"
>
>Thanks for your help
>Todd