Good Morning All
I am hoping you can assist me with an issue I am having running a macro on Excel 2007.
I have recorded a macro that involves splitting one cell containing date ddmmyyyy and time (24 hour) hh:mm:ss into two one with the date and one with the time.
This is not an issue when I record it but when I run it using test data the time format goes to a 12 hour format and adds a cell containing AM or PM.
I do not know why the time changes format. I have tried re recording the macro, clearing formats and also during the recording ensuring the time format is in the correct format. All to no avail, when I press play it goes to 12 hour format with the new AM or PM column.
Am I missing something very simple? Please can somebody point me in the right direction.
Many Thanks
Stuart
Bookmarks