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