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