>>>hi,
>>>thank you for reply,
>>>no errors but zeroz still.
>>>

>>>*select myTable
>>>use answers excl
>>>local lnI,laFields[1]
>>>afields(laFields)
>>>for lnI = 1 to alen(laFields,1)
>>>    blank fields (laFields[lnI,1]) for empty(&laFields[lnI,1])
>>>next
>>>BROW
>>>

>>
>>Hmmm, AFAIK it should work. Unless you're examining the resulting Excel file.
>
>If it's for export to Excel, it'll always show zeros there... unless the content is exported to clipboard via _vfp.DataToClip(,,3) and then pasted in Excel (which can be done programmatically through automation).

Did you try to replace with NULLs? I know it works for dates.