Forgot to mention that Excel does not recognise dd.mm.yy as a date.

"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