Thread: Need Help Creating a Macro to Delete Date and Number Information
View Single Post
 
Old 02-28-2016, 05:12 AM
rsrasc rsrasc is offline Windows 10 Office 2013
Competent Performer
  
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default
Hi PhilB1,

Thanks again for the info provided. I was able to change the date format using the below code. After that I ran your color code macro and is highlighting the date format
in red. So with your other macro I was able to delete the date info in column A.

Code:
Sub ConvertingDateFormat()
'
' Macro3 Macro
'

'
    Columns("A:A").Select
    Selection.NumberFormat = "mm/dd/yyyy"
    Range("A1").Select
End Sub
Therefore, I'm happy with the outcome.

Thanks again for taking your time helping me on this.

Cheers!
Reply With Quote