>>>Try something similar to this:
>>>

>>>* suppress zeros, format as currency, for negative numbers use () and red color
>>>.columns("J:K").NumberFormat ="$#,##0.00_);[Red]($#,##0.00);;@"
>>>

>>>
>>Thanks, Yuri.
>
>You are welcome.

Yuri,

I'm having some weird problem with a character field. I just posted a new thread, may be you can help me out.

Thanks again, the currency fields worked great.