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

[Tom Ogilvy]

exactly.

--
Regards,
Tom Ogilvy


"ina" wrote:

> 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
>
>

[ina]

thanks