thanks for that,

well i tried it, but it is still the same. If you choose any date abov
the 12th then the date is displayed correctly, But if u choose a dat
with the day less than or equal to the 12 then it is displayed a
mm/dd/yyyy.

very confusing (and irritating!)

any more ideas?

--
s_ali_hassa
-----------------------------------------------------------------------
s_ali_hassan's Profile: http://www.excelforum.com/member.php...fo&userid=3532
View this thread: http://www.excelforum.com/showthread.php?threadid=55724