(Paste:=xlPasteAll, Operation:=xlAdd) | generates year = 2127

[Bscgo024]

Dear Readers,

I have an issue where my macro is changing the standard "mm/dd/yyyy hh:mm" Number Format into the year 2127. My Macro is below:

Please Login or Register  to view this content.

My Database generates the date (2013-07-19 12:41) which is incalculable against other dates. When I copy a blank cell, select the row, paste special "Add", excel transforms the number into (02/13/2127 22:13).

If someone could kindly offer an explanation or solution on how to convert my date and time field into a calculable cell I would be extremely grateful for your knowledge and advice.

[protonLeah]

You don't specify what's in A5000, nor why you're adding it to dates in column I.