Convert SAP date format

[roughleg]

I'm needing to do some calculation concerning time used from a spreadsheet that is downloaded from SAP. SAP records dates in our system by dd.mm.yyy using periods as separators (30.3.2014). Is there a way to convert these dates which reside in one column into a date that Excel can recognize in a formula??? eg. 3/30/2014

 

[Ron Coderre]

Try this to convert the values:
• Select the single-column range of "dates"
• Data.Text-to-columns.....Click: Next....Click: Next
...Check: Date DMY
...Click: Finish

Is that something you can work with?

 

[roughleg]

Yes, thank you. I was about to kill this post as I realized my manager had his spreadsheet dates formatted for UK. Sorry.