+ Reply to Thread
Results 1 to 1 of 1

Find and replace the date format in Word file

  1. #1
    Registered User
    Join Date
    07-25-2010
    Location
    chennai
    MS-Off Ver
    Excel 2016
    Posts
    48

    Smile Find and replace the date format in Word file

    Hi,

    I want to find and replace the Date format in word, if there is any macro coding for this. I try to using the following codes

    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
    .Text = " 7/"
    .Replacement.Text = " 07/"
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
    End Sub

    But "7" is relates to month, so if there is any code for change the numeric character to specific date format as "mm".

    For ex :

    BUARDC 04294008295 010321 6000 7/17/2010 0000354652 000224

    The above is the example data , in that month needs to added a leading zero.

    Thanks in advance
    Last edited by vinwin06; 08-01-2010 at 06:29 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1