hi,
thank you for reply
if trans(yourfieldS)='0'
blank yourfieldS
endif
>
if trans(yourfield)='0'
> blank yourfield
>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?
>>>>>