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..?

whe
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


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=401411