Hello,
I’m new to excel VBA programming and have a pretty big challenge ahead of me – I’ll appreciate your thoughts on that. Let me describe my problem.
I have a data copied from some source where one of the columns is intentionally formatted in two different formats – text and date, for example there’s “01-Jan” and “0-1”. I’d like to have both of the values to be in text format so that I have “1-1” and “0-1”.
Is there any way to replace the date format with text format and copy it to some parallel column ?
Or maybe there's some other way than via the vba code ?

Any help will be appreciated!
Charles