I have recorded a macro where I go to a cell and paste from the clipboard.

One of the fields in the data that I paste is a Date field. When I compare
the same data (one pasted manually and one with the macro) with an exact
formula I get false results for dates. The date is the same and in the same
format (DD/MM/YYYY HH:MM:SS) for both. The only difference I can see is that
dates for the macro paste are to the right of the cell and manual paste is to
the left.
I know normally TEXT goes to the right and Values go to the left.
I do not understand why the manual and macro paste have different results
and is there a way around it?




This is a section of the Macro
'
Range("B936").Select
Application.Goto Reference:="R954C3"
ActiveSheet.Paste


Thanks
Paul