Convert two different format/values into one format

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

Attached. This is just an example based on a few lines.

Let me know if this is doable please.

Thank you,
Charles

Cannot open the picture, can you re-upload it ?

It opened just now. Thank you.
I figured out this solution too, however it only partially resolves my issue. The thing is that when I reference the cell that was originally copied from the source (date format) and use for example LEFT and RIGHT functions to take the numbers without the dash into two separate cells then it still sees the data as date and whenever copied as values to another cell it returns for example "43466" for "1-1" (01-Jan).

Is there any way to avoid this ?