Check your regional options in Windows Control Panel.
--
David Biddulph

"Venkatraman" wrote in message
...
Hi,
When I try to import a set of dates from Internet explorer, the date
format
changes to US date format those dates are =<12. If I try to convert those
date format the dd/mm/yyyy shuffles to mm/dd/yyyy.

Ex:
1/10/2007 changes to 10/01/2007 (Problem date)
13/10/2007 changes to 13/10/2007 (No problem)

But my requirement to change from 1/10/2007(US) to 1/10/2007(UK)

Can anyone help me?

Thank you
Venkat