| 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 |
| 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) | |||
Threaded Mode
