need help converting this date in a real date

[xclaim]

need to convert these dates into real date - please note that the first character in the cell is a blank/space which i can trim out i believe. thanks in advance.

[TABLE="width: 115"]
<tbody>[TR]
[TD] 18-JAN-13
[/TD]
[/TR]
[TR]
[TD] 01-FEB-13
[/TD]
[/TR]
[TR]
[TD] 15-FEB-13
[/TD]
[/TR]
[TR]
[TD] 08-MAR-13
[/TD]
[/TR]
[TR]
[TD] 05-APR-13
[/TD]
[/TR]
[TR]
[TD] 21-JUN-13
[/TD]
[/TR]
[TR]
[TD] 14-DEC-12
[/TD]
[/TR]
[TR]
[TD] 21-DEC-12
[/TD]
[/TR]
[TR]
[TD] 17-MAY-13
[/TD]
[/TR]
[TR]
[TD] 14-DEC-12
[/TD]
[/TR]
[TR]
[TD] 21-DEC-12
[/TD]
[/TR]
[TR]
[TD] 21-DEC-12
[/TD]
[/TR]
[TR]
[TD] 28-DEC-12
[/TD]
[/TR]
[TR]
[TD] 04-JAN-13
[/TD]
[/TR]
[TR]
[TD] 11-JAN-13
[/TD]
[/TR]
[TR]
[TD] 18-JAN-13
[/TD]
[/TR]
[TR]
[TD] 25-JAN-13
[/TD]
[/TR]
[TR]
[TD] 25-JAN-13
[/TD]
[/TR]
[TR]
[TD] 01-FEB-13
[/TD]
[/TR]
[TR]
[TD] 08-FEB-13
[/TD]
[/TR]
[TR]
[TD] 15-FEB-13
[/TD]
[/TR]
[TR]
[TD] 22-FEB-13
[/TD]
[/TR]
[TR]
[TD] 01-MAR-13
[/TD]
[/TR]
[TR]
[TD] 08-MAR-13
[/TD]
[/TR]
[TR]
[TD] 15-MAR-13
[/TD]
[/TR]
</tbody>[/TABLE]

 

[barrowb]

If you type those in Excel should automatically recognize them as dates. At least it does in my Excel 2007.

 

[Norie]

Select the dates, goto Data>Text to columns..., on the 3rd step choose DMY from the column data format dropdown and then click finish.