Formatting a column to display the date and time instead of general text using VBA

Hi All,

I am struggling with the formatting of two columns in worksheet. I am running the workbook as shared so I can track any changes through the history. I have multiple worksheets that I want to track, I have managed (with help) to copy the history for each worksheet out and into e.g. a new History-for sheet 1 and History-for sheet 2 etc allowing me to focus on the history for each individual worksheet. The history is copying over into the specific sheets fine apart from the date and time stamp, they both seem to converted to general text.

Can anyone tell me why this happening and what code I could use to convert column 2 of History-sheet 1 to time format and column 3 to date format.
I am using excel 2007

Thanks in advance

Novice coder

Hi,

Yes I have tried this and it works but I would like to do it under VBA if possible.

Thanks

Why don't you turn the macro recorder on, then change the formats manually, then stop recording and see what code you have generated. You should then be able to copy those few lines into your existing macros.

Hope this helps.

Pete

Try these codes

Please Login or Register  to view this content.

Thanks for help, I have used the code and placed it in with the rest of my code and it works fine, although I have changed "[$-409]h:mm AM/PM;@" to hh:mm:ss. Thanks again