Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |