Dates in Excel VBA are interpreted as US English format if it is at all
possible. You have described this behavior in detail.

This isn't a bug, but designed behavior.

See Stephen Bullen's site for information on international considerations.
http://www.oaltd.co.uk/ExcelProgRef/...rogRefCh22.htm
International Issues

--
Regards,
Tom Ogilvy





"stephenb" wrote in
message ...

Jezebel, thanks for a response. While your reply may be true in many
cases, I still don't feel it's helped me. If you quickly try what I
have done as described in my original post I think you will understand
what I mean (it's simple and won't take long). I have also tried to
remove assumptions by formatting cells before and after the paste and
yet the problem still occurs. To me it appears to be an Excel bug,
unless someone can prove otherwise or perhaps provide a workaround.
Thanks again.


--
stephenb
------------------------------------------------------------------------
stephenb's Profile:
http://www.excelforum.com/member.php...o&userid=28726
View this thread: http://www.excelforum.com/showthread...hreadid=484187