>>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).