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