Hi Guru's,
I've tried today at work to fix this and now I'm now brain dead, so I'm asking for help.
When I download a report from a supplier's website they have the date & time as text in a colum (1,000 + rows)
Text example: Jan 11 2013 15:30 or Oct 2 2012 8:50
I need these to be date.time format:
Date example: 11/01/2013 3:30:00 PM or 2/10/2012 8:50:00 AM
I'm running a VBA over the report for formating other columns, so I'm ok with either a VBA answer or an Excel Formula answer.
I've tried today at work to fix this and now I'm now brain dead, so I'm asking for help.
When I download a report from a supplier's website they have the date & time as text in a colum (1,000 + rows)
Text example: Jan 11 2013 15:30 or Oct 2 2012 8:50
I need these to be date.time format:
Date example: 11/01/2013 3:30:00 PM or 2/10/2012 8:50:00 AM
I'm running a VBA over the report for formating other columns, so I'm ok with either a VBA answer or an Excel Formula answer.