Hello everyone,
I receive a report that has a European date and time formatted as the below:
2/10/2012 5:49
I need this to be in American date and military time format.
I have tried every single thing I can think of using custom formatting, text to columns, etc. When I MANUALLY format it using military time and then perform text to columns, it splits out the date, converts it to the American version (10/2/2012) and splits out the time and converts it to military time.
However, not one single line of VBA code I've tried will do this. Every time it runs, it splits out the date and converts it to the American version (10/2/2012). However, the time is always coming out as a normal 12 hour clock cycle with an EXTRA column indicating AM/PM.
Does anyone know how to fix this? I've spent three days on this.
Thanks!
Bookmarks