Perhaps just in say, B1: =A1,
and format B1 as general would suffice
(or format A1/col A as general)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gazzr" wrote in
message ...

Hi All,

Can anyone tell me why my formula =datevalue(A1) returns #Value when
the contents of A1 are 13/01/2005.

When I am converting 12/01/2005 the formula works. I think its
something to do with the US/UK version of expressing dates but I cant
work out how to fix it!

Regards
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile:
http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=525986