Hi everyone, I have a problem with this following query:
I have a list of cells in the text format: 01.01.05 which relates to 1st Jan 2005 is there a way to change this so that it becomes a date..?
where:
01.01.05 (text) would become 01/01/2005 (dd/mm/yyyy date format)
05.10.05 (text) would become 05/10/2005 (dd/mm/yyyy date format).
Thank you for all your help.
love Amy xx
Bookmarks