How can I change a date to UK format without shuffling the actual
 

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

How can I change a date to UK format without shuffling the actual
 

On Mon, 3 Sep 2007 06:44:03 -0700, Venkatraman
wrote:

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

Excel parses dates according to the Windows Regional Settings which are
accessible via the Control Panel.

You need to ensure that the date you are importing and the Regional settings
match.

The cell format settings in Excel itself do NOT affect how the date will be
parsed.
--ron

How can I change a date to UK format without shuffling the actual
 

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

How can I change a date to UK format without shuffling the act
 

It works well.

Thank you for your useful information.

Venkat

"Ron Rosenfeld" wrote:

On Mon, 3 Sep 2007 06:44:03 -0700, Venkatraman
wrote:

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

Excel parses dates according to the Windows Regional Settings which are
accessible via the Control Panel.

You need to ensure that the date you are importing and the Regional settings
match.

The cell format settings in Excel itself do NOT affect how the date will be
parsed.
--ron