FW_ExcelToDBF : number and text issue

[Marc Venken]

While trying to read exel data and storing to dbf i often have following.

The first column is a reference code and has a mix of numbers and text data. (I have no impact on these data)

The function often converts it to :

Code Result Hoping to get
1234 1234.00 1234
Txt1234 Txt1234 Txt1234

I changed the column in exel to text format, but still Fw converts as number.

How do I solve this ?