IF VARTYPE(ValueInTheCell) = "C"
  * String

>Is there a function that can help me to determinate if the content of a cell (or a variable)is a String or a number??
>
>I´m trying to get some values from Excel. Sometimes, the value starts with a letter (E-100000) and others just the number. The field in the table is Character. I´m trying to do something like this:
>
>

>If (SomeFunctionToSpecifyIfNumber) then
>     replace mytable.myfield with alltrim(str(ValueInTheCell))
>else
>     replace mytable.myfield with ValueInTheCell
>endif
>

>
>Any idea?? Thanks in advance!