Pasting date values from clipboard - help

Hi,
I am pasting into a cell from clipboard, however date values change their original format. Is it possible to paste everything as text ??

Here's my Macro code:

Please Login or Register  to view this content.

Welcome to the Forum.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

To avoid messages like this take a look at the "How to" menu in the blue Forum Toolbar. I will add the tags this time

Why do you need to do it that way? You can just use Copy & PasteSpecial
.