I have a DTPicker set up in a simple userform. The subject picks the date, and then either hits Cancel..to cancel the procedure, or hits OK which copies the date into the word document.

The date format is curently dd/mmm/yyyy.

Is there any way to change that to ddMMMyy, i.e. 22AUG12?

Cheers,