View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Venkatraman Venkatraman is offline
external usenet poster
 
Posts: 2
Default 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