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
Bookmarks