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

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

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