Thanks Yuri,
That worked great.
jfh
>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);;@"
>
>
>>Hello all,
>>I'm having a problem formatting some Excel columns to display as currency. Here is the code I'm using, taken from Excel's Macro Editor. In this case, the VFP code is the same as the VB. Here it is:
>>
>>.Columns("J:K").Select
>>.Selection.Style = "Currency"
>>
>>(this is, of course, wrapped in a WITH...ENDWITH)
>>
>>This blows up on the second line, says "Invalid number of parameters". I also tried it by selecting an individual cell (to see if maybe it didn't like the columns), but received the same error. Thanks for any assistance,
>>
>>jfh