Hi, I am using vba to import a flat file into a work sheet, using:

ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False, NoHTMLFormatting:=True

The problem is that the data is in dd/mm/yyyy format. However, for all dates where the dd is 12 or less the import returns mm/dd/yyyy.

How can I force it to use dd/mm/yyyy?
Or mm/dd/yyyy - I can use either but the mixture of formats is difficult (impossible) to use effectively

Thanks, Peter