#1   Report Post  
Posted to microsoft.public.word.docmanagement
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Greg Maxey
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Header with picture or text box Scott Page Layout 15 April 28th 23 02:52 AM
Convert text in Word to table or Excel Albert Microsoft Word Help 3 January 11th 06 03:06 PM
Way to hide text without hidden text font? [email protected] Microsoft Word Help 6 December 11th 05 09:53 PM
convert field codes to text in table of contents J.Enevoldsen Microsoft Word Help 2 April 15th 05 05:07 AM
textbox to normal text Jack Sons New Users 16 December 5th 04 03:44 PM


All times are GMT +1. The time now is 04:53 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"