What's wrong with this recorded macro please ?

The following is a recorded macro which Paste Special Operation Adds a '0' to dates in order to turn them from text into a date number. The process worked fine when I recorded it, but when I try to run it back it just won't seem to do the Paste Special Operation Add part to turn the text dates into numbers.

Please Login or Register  to view this content.

I've recorded and re-recorded all the above steps a few times but still it doesn't work. Would anyone be able to advise please ?

Thanks

TW

You can try this macro and see how it works for you.

Please Login or Register  to view this content.

"0" in quotes is not the number 0, but the character string.

Please Login or Register  to view this content.

The column of dates look like normal dates but are left justified, i.e. text but when I run the macro they don't change at all.

When I do it manually, this is what happens..

17/04/15
becomes
42111
which after formatting the cell as Date becomes
17/04/15

(i.e. right formatted in the cell as opposed to left formatted)

Thank you ProtonLeah, feel a fool for not seeing that but then again it was an error created by the macro recorder.. A lesson there..

Skywriter, that works an absolute treat. Thank you

Skywriter, that works an absolute treat. Thank you

My pleasure. Thanks for the rep. points.