Need Help Creating a Macro to Delete Date and Number Information

rsrasc · #7 02-28-2016, 05:12 AM

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a Template using a Macro to fill in various information	brojames	Word	7	11-09-2015 02:51 PM
Creating a Document that Pushes Information to other Word Documents	jbwhisler	Word	2	08-25-2015 12:12 AM
How to find number of coma and then add that number of rows in word using macro?	PRA007	Word VBA	7	05-27-2015 10:45 PM
Delete starting number *) and delete Unneeded data in series	frustrated teacher	Word VBA	5	12-07-2014 06:53 PM
How to Automatically Add/Delete Columns Based On Information	kconnolly	Excel	7	04-08-2014 07:23 AM