how to change excel column cells format to "Date" time in runtime.

[kkc]

Hi guys,
i am facing a problem here.
i have a microsoft access program, which will import excel spreadsheet data into database.

however, before i import the spreadsheet, i need to change a column cells format.
i.e i have a worksheet, let assume, WS1
in WS1, the first column, Column A cells format is "Custom"
i want to change it to "Date" format,
how can i do that?
please advice.

[[Pieter]]

Try this:

WS1.ActiveSheet.Range("A:A").NumberFormat = "dd/mm/yy hh:MM:ss;@"

Pieter

[kkc]

thanx,
it works.