You are welcome! Thanks for the feedback!
Stefi
Clicking the YES button will be appreciated.


€žBoss€� ezt Ã*rta:

Thanks Stefi
Boss

"Stefi" wrote:

Columns("B:B").NumberFormat = "h:mm;@"
probably solves your problem.

Regards,
Stefi

€žBoss€� ezt Ã*rta:

I have a situation in which i have lot of excel files in a folder. All with
same formats. All of them have time column in column B.

In some of the sheets data is filled in the fomrat (01/01/1900 09:00:00)
and in some of them it is in (09:00) format.

I need to bring all of them into similar formmat (09:00).

I need to do this because i change the time into values and then run another
macro which bring required data for me.

please help with any ideas codes to colve this.

Thanks!
Boss