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

[Venkatraman]

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

 

[Ron Rosenfeld]

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

 

[David Biddulph]

Check your regional options in Windows Control Panel.

 

[Venkatraman]

It works well.

Thank you for your useful information.

Venkat