Quote Originally Posted by xtinct2 View Post
There are vast amounts of columns with dates in these formats, so I can't use a formula b/c it'd require having a formula column for each static column.
The result doesn't need to have propertices of a date -- just needs to be in the yyy-mm-dd format -- even if excel only recognizes it as text, that's fine.

Doesn't see like it's possible, though
Thanks all!
Sorry but why you are not looking forward to vba . I saw you mentioned some where abt that.