Hi, I have a date field being exported from an asp OMS, This field is sometimes populated as YYYY-MM-DD. When the year is shown first the format I end up with on export in excel looks like this 20/07/8/6/ instead of 8/6/2007
I was looking for some vba code to re-format this definitive pattern so it would be formatted MM-DD-YYYY, to be run on a button click function in my existing macro project.
It needs to be recognized as a TRUE date format because I pull the YEAR out from a helper column. (and yes it'd be GREAT to fix the date format in the OMS befre export, but that will not happen any time soon and i have no control over that change, only this export part!)
Any suggestions how this can be done? THANKS!
using excel 2007
Bookmarks