ExcelBanter - Problem with Date Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Problem with Date Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/19695-problem-date-formatting.html)

The Data Detective

Problem with Date Formatting

I am importing a text file with dates in the format 3/1/05. I need the data
formatted as DD-MMM-YYYY. I can get this for all dates EXCEPT where the
leading zero has been dropped off the day, such as 3/1/05.

Can anyone suggest how to do this in Excel?

All times are GMT +1. The time now is 12:32 PM.