how can I use VBA to format a column to currency
 

I'm trying to use code to force the entire column to be currency. I also
have another column I'm trying to force to text, any help is appreciated

how can I use VBA to format a column to currency
 

Columns(3).Numberformat = "$#,##0.00"

Columns(4).NumberFormat = "@"

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"SITCFanTN" wrote in message
...
I'm trying to use code to force the entire column to be currency. I also
have another column I'm trying to force to text, any help is appreciated

how can I use VBA to format a column to currency
 

Use the macro recorder while you format the column manually. That should
give you the start you need.

Regards

Trevor


"SITCFanTN" wrote in message
...
I'm trying to use code to force the entire column to be currency. I also
have another column I'm trying to force to text, any help is appreciated