You're welcome.
>Worked great. Thanks again Sergey.
>>Try
>>*
>> .NumberFormat = "###,###,###"
>>* Or condtional formatting
>> .NumberFormat = "#[=0];###,###,###.00"
>>
>>
>>>
>>>Is there a way to not display a 0 value in a excel formula like @Z does in vfp?
--sb--