With my windows short date set for mm/dd/yyyy, I got May 10, 2005.

But I think (untested) if the short date format matched (dmy), then the formula
would work fine.



KL wrote:

how about: =--SUBSTITUTE(A1,".","/") and format the cell as date.

Regards,
KL

"AmyTaylor" wrote
in message ...

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


--

Dave Peterson