had1015
02-17-2014, 02:45 PM
Hi,
I need some help as I'm using macros for formatting csv files to excel reports. There are instances where the csv data may have something like "APR14", "MAY15", "JUN16" or any other month with the year following. When I get then into excel the year always is turned on the left side thereby becoming dates something like "14-Apr" or "14-May" of the current year. I would like vba code that will convert it back to its original format like "APR14", "MAY14", "JUN14".
Any assistance would be greatly appreciated.
I need some help as I'm using macros for formatting csv files to excel reports. There are instances where the csv data may have something like "APR14", "MAY15", "JUN16" or any other month with the year following. When I get then into excel the year always is turned on the left side thereby becoming dates something like "14-Apr" or "14-May" of the current year. I would like vba code that will convert it back to its original format like "APR14", "MAY14", "JUN14".
Any assistance would be greatly appreciated.