Date time format

  • Thread starter Thread starter Boss
  • Start date Start date
B

Boss

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
 
Columns("B:B").NumberFormat = "h:mm;@"
probably solves your problem.

Regards,
Stefi

„Boss†ezt írta:
 
You are welcome! Thanks for the feedback!
Stefi
Clicking the YES button will be appreciated.


„Boss†ezt írta:
 
Back
Top