>>>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.
If it's not broken, fix it until it is.
My Blog