There is nothing to turn off. Pasting dates results in then taking whatever the default date format is for your system. If you want to use another format, either paste them as values into pre-formatted cells (otherwise you'll just get serial #s) or paste then re-format.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]