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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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