hi,
thank you for reply

if trans(yourfieldS)='0'&&i have many fields at mytable
  blank yourfieldS && or replace yorufieldS with .null.
endif

>

if trans(yourfield)='0'
>  blank yourfield && or replace yorufield with .null.
>endif

>
>>hi,
>>
>>i'm sorry ,
>>i have another type need to convert to null or space ...
>>type double and integer.
>>
>>thanks
>>
>>>If this is the case, you should make them NULL, not blank, AFAIK.
>>>
>>>Change the command to
>>>replace (laFields[lnI,1]) with NULL for empty(&laFields[lnI,1])
>>>
>>>Check Re: Blank dates in Excel Thread #1140736 Message #1142863
>>>
>>>>yes,
>>>>i convert this table to excel sheet, i found many records have zeroze...
>>>>
>>>>>You cannot fill space to numeric field. Maybe you want to show blank on screen when table field value is zero?
>>>>>