>>>>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.
That was on previous job, and that one was a NO NULLS job. House rule. So I didn't even try that.