Date Format

[dodokh]

Hello

How can I change 1-12-2015 to 1-Dec-15 ?

I have tried format cells > Date but it didn't work.

Thank in advance

 

[Peter_SSs]

.. the key for me is selecting the MDY in the Date option as the date was in that format. I then re-format it to dd/mm/yyyy in EXCEL.

Exactly. The Text to Columns simply produces a date. How you format that date is completely up to you - as with any other date cell(s).

Anyway, glad we got you going. Thanks for letting us know.