Numberformat issue

[ina]

hello,

I would like to change the format of a column but I do not want to
select it, do you think it is possible to do something like this

Columns("C:C").NumberFormat = "yyyy/mm/dd"

Ina

 

[Die_Another_Day]

I use the column number like this:

Columns(i).NumberFormat = "yyyy/mm/dd"

where i = column number

Die_Another_Day

 

[Guest]

exactly.

 

[ina]

thanks