Date 'Unformatting' Issue

Greetings all,

I am working with data that is formatted as such: 1-10-50 or 3-15-50, etc.; naturally, excel turns this into 1/10/1950 or 3/15/1950, etc. Is there some code that can help me turn this back to the original formatting. (btw, setting the cell to text does not work).

The finished cell content needs to be:

1-10
3-15

These are not dates as excel would like to think.

I am currently working with a rather verbose loop 'text to columns' code and I am looking for something that will work a little faster.

Thanks in advance for all your help

Doesn't setting the cell format to dd-mm-yy work for you?

Doesn't setting the cell format to dd-mm-yy work for you?

Bob,

Thank you for responding...

Please accept my apology, I ommitted part of my post, which I have now edited. The goal here is to remove the '/1950' and simply end up with 1-10, 3-15, etc, but not formatted as dates, as the original data are not dates.

Thanks again

-RT91

Use a formula

=TEXT(A2,"d-mm")

Bob, you are a genius!

For the sake of other posters I changed your formula to =TEXT(A2,"m-dd") and it worked as you knew it would...Thank You, Very Much!!