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?