DataText to ColumnsNextNextColumn Data FormatDMYFinish.

Works for me in Excel 2003 with your example data.


Gord Dibben MS Excel MVP

On Wed, 21 Jan 2009 06:54:04 -0800, Celtic Warrior
wrote:

Thanks guys for the quick response but no luck with your solution.


Warrior.




"Gary''s Student" wrote:

Select the cell(s) and Format Cells... Number Custom dd/mm/yy
--
Gary''s Student - gsnu200828


"Celtic Warrior" wrote:


How do I convert a date format from dd.mm.yy to dd/mm/yy?

Any help appreciated