I have a spreadsheet with a column formatted as:

> 
> Category: Date  
> 
>  Type: \*dd/mm/yyyy  
> 
>  Location: UK
> 
> 
> 

When I read the data in this column via VBA, it reads in the format mm/dd/yyyy.

For example, 10/06/2014 (10 June 2014) is reading 06/10/2014 (06 Oct 2014).

My code: `sDate = SourceSheet.Range("AB" & CurRow.Row).Value`