I have a report extracted from shop software into Excel 2010. Unfortunately in column A I have job number (in text format) in row 1 and due date (in date format) in row 2 and so on...

COLUMN A
ROW1 Job No
ROW2 Due Date
ROW3 121033
ROW4 01/24/13
ROW5 121018
ROW6 01/31/13
ROW7 121019
ROW8 01/31/13

I would like to have them separated, or at least COLUMN B showing me only date (DUE DATE), have no need for JOB number (Job No)

I tried this IF function:

=IF(ISERROR(DATEVALUE),TEXT(A17,"mm/dd/yyyy")," ")
but it turns the job number (in text format) into a date

any ideas, my brain is either overthinking this, or I'm really in lack of coffee to see the simple solution.