software

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: www.excelforum.com/member.php...oamp;userid=31075
View this thread: www.excelforum.com/showthread...hreadid=525986Perhaps just in say, B1: =A1,
and format B1 as general would suffice
(or format A1/col A as general)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Gazzrquot; gt; wrote in
message ...
gt;
gt; Hi All,
gt;
gt; Can anyone tell me why my formula =datevalue(A1) returns #Value when
gt; the contents of A1 are 13/01/2005.
gt;
gt; When I am converting 12/01/2005 the formula works. I think its
gt; something to do with the US/UK version of expressing dates but I cant
gt; work out how to fix it!
gt;
gt; Regards
gt; Garry
gt;
gt;
gt; --
gt; Gazzr
gt; ------------------------------------------------------------------------
gt; Gazzr's Profile:
www.excelforum.com/member.php...oamp;userid=31075
gt; View this thread: www.excelforum.com/showthread...hreadid=525986
gt;
Hi Garry,

I think you have US English set in Windows Regional Settings while you are
trying to convert British date format strings into dates. You have two
options:
1. Change your Regional Settings to UK English,
2. Create US style date strings to convert: not 13/01/2005 because in UK
usage it would mean 01. of 13th month (there is no 13th month, that's why you
get #Value) , but 01/13/2005 which in US usage means 13. January 2005.

Regards,
Stefi?azzr??ezt ?rta:

gt;
gt; Hi All,
gt;
gt; Can anyone tell me why my formula =datevalue(A1) returns #Value when
gt; the contents of A1 are 13/01/2005.
gt;
gt; When I am converting 12/01/2005 the formula works. I think its
gt; something to do with the US/UK version of expressing dates but I cant
gt; work out how to fix it!
gt;
gt; Regards
gt; Garry
gt;
gt;
gt; --
gt; Gazzr
gt; ------------------------------------------------------------------------
gt; Gazzr's Profile: www.excelforum.com/member.php...oamp;userid=31075
gt; View this thread: www.excelforum.com/showthread...hreadid=525986
gt;
gt;