| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE
Please advise how I can change a series of dates in US Format eg 11/23/2004
into European format 23/11/2004 ie 23 Nov 2004. I am using Excel 2002. Thanks Roland |
|
#2
|
|||
|
|||
|
Hi
fi your values are stored as Excel date values simply use 'Format - Cells' and choose your desired (custom) format -- Regards Frank Kabel Frankfurt, Germany "Roland" schrieb im Newsbeitrag ... Please advise how I can change a series of dates in US Format eg 11/23/2004 into European format 23/11/2004 ie 23 Nov 2004. I am using Excel 2002. Thanks Roland |
|
#3
|
|||
|
|||
|
Use a custom format dd/mm/yyyy
if you are sending a workbook with US dates to someone with European regional setting it will be converted automatically Regards, Peo Sjoblom "Roland" wrote: Please advise how I can change a series of dates in US Format eg 11/23/2004 into European format 23/11/2004 ie 23 Nov 2004. I am using Excel 2002. Thanks Roland |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Linear Mode
