Macro to correct date error

[stillakid]

I have a query to download some information out of my computer system. When I run the macro there are some places where the date is showing up as 09/26/13ⁿ09/26/13ⁿ09/26/13


What can I add/change in my macro to only get 1 date?

Thanks,
Sue

[newtotheblock]

Sheets(1).Range(A1) = Format(Now, "dd/MM/yyyy")