If you just store a date in an Excel worksheet, it should adapt to the
user's settings.

What situation do you have, and what is your goal, as I think the real
question is a bit earlier in the process <g?

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"gabch" wrote in message
...

Hi,

How can I convert UK date format(dd/mm/yy) at cell to US format
(mm/dd/yy) through VBA


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=545403