That didnt work either Its still pasting as General
I guess i'll just have to format each column individually after pasting

e.g.

Range("A4:A100").NumberFormat = "dd/mm/yyyy"