My Excel version - 2010. I have recorded a macro to manipulate, sort and delete unneeded gobblygook data that I receive from a JDEdwards export. It works perfectly but there are a couple more steps I need to happen which I now have to do manually. I end up with 3 columns of data - A, B, and H, that I have to convert to numbers. Column "A" is actually a date that I have to convert to 20XX and then format it to XX/XX/XX (ie 01/14/14).

When I tried to do these things while recording my macro, I was made aware of the fact that those steps are not allowed. Attached is a sample of the JDE exported data I receive daily and a copy of my macro vba. I would greatly appreciate if someone could help me with code that will do these three things:

1. Convert column "A" to 20XX date.
2. Format columnn "A" date to XX/XX/XX.
3. Convert columns "B" and "H" to text.



Sub DataSort.doc Test.xlsx

Best regards!