Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Convert text to date
I would like to convert text in the form of M/d/yy to a date in the
form of MMMM d, YYYY. Any ideas? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Convert text to date
You could select the date and run this macro:
Sub FormatTheDate() Dim oSel As String Dim MyLongDate As String oSel = Selection.Range.Text MyLongDate = Format(CDate(oSel), "MMMM d, yyyy") Selection.Range.Text = MyLongDate End Sub -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. wrote: I would like to convert text in the form of M/d/yy to a date in the form of MMMM d, YYYY. Any ideas? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Convert text to date
Thanks, that works great. I was hoping that you might know of a way to
do it in a field formula that automatically converts the entry. I have bookmarks that are entered in the M/d/yy format that need to be converted throughout a document. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Header with picture or text box | Page Layout | |||
Convert text in Word to table or Excel | Microsoft Word Help | |||
Way to hide text without hidden text font? | Microsoft Word Help | |||
convert field codes to text in table of contents | Microsoft Word Help | |||
textbox to normal text | New Users |