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
|