New
#1
MS Office 2010 - Word Macro
I am a novice at this and I have searched and searched over the last week trying to figure out a fix to this.
I'm trying to create a Word Macro to remove time from date:
This occurs in 4 different cells.
Cell in Word shows: 05/04/2016 10:00:00
I just need the date to show without the time.
Looking for a code that will make this happen.
Code that I have used for other issues looks something like this, however, the below example is what I'm trying to accomplish:
________________________________________________
Sub TIME()
'
' TIME Macro
'
With Selection.Find
.ClearFormatting
.Text = "??:??:??"
.Replacement.ClearFormatting
.Replacement.Text = ""
.Execute Replace:=wdReplaceAll, Forward:=True, _
Wrap:=wdFindContinue
End With
End Sub
________________________________________________
Any help would be greatly appreciated!
:)