correcting date time format

[rdgsilver]

I have a program that exports data to an excel spreadsheet. Sounded great until I tried to do some calculations based on a cell containing time date data. Every time I try I just get the #VALUE error. I am running Mac Excel 2011, and have formatted the offending cells to "mm/dd/yyyy hh:mm:ss".

Example of cells: 8/5/2013 20:29:43

 

[Andrew Poulsom]

Welcome to MrExcel.

I don't have a Mac, but Data|Text To Columns choosing Date MDY at Step 3 should do the conversion for you.