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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
Back
Top