DTPicker date formatting

Andy2011 · #1 08-21-2012, 11:28 PM

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,

macropod · #2 08-24-2012, 02:45 PM

Cross-posted at: http://www.excelforum.com/word-progr...-dtpicker.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date formatting	kjxavier	Excel	18	08-23-2011 08:21 AM
Date formatting	kjxavier	Excel	6	08-12-2011 05:46 AM
Date formatting	kjxavier	Excel	0	08-10-2011 08:17 AM
Date Formatting in MS word 2007	Karthick	Word	4	01-19-2010 05:54 AM
Inserting Date, formatting to superscript and subscript	louq	Word	1	10-22-2009 09:29 AM