#1
|
|||
|
|||
Date Conversion
Is there a way to automatically convert date entries dd/mm/yyyy in specific cell to Month dd, yyyy (example 25/12/2012 convert to December 25, 2012) help appreciated. |
#2
|
|||
|
|||
If you place a date picker content control in the cell and set its properties with a MMMM dd, yyyy format then if you type 12/25/2012 into the date picker it will convert when you exit the content control.
|
#3
|
||||
|
||||
Cross-posted (and answered) at: http://www.excelforum.com/word-forma...hanumeric.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Field to add 10 Days to Current Date | Erbwon | Word | 6 | 11-12-2012 06:17 PM |
Meaning of current date vs status date when saving baselines | ketanco | Project | 1 | 02-08-2012 02:20 PM |
Task with Start date but no Due date? | bplat | Outlook | 0 | 01-12-2012 08:10 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |