|What exactly are you copying? Is it just a 4 digit year or an entire date or something else?|
What data base are you copying from? What process are you suing?
The more details you provide the easier it will be for us to help you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.