converting from US to EURO date format

  • Thread starter Thread starter JOhn
  • Start date Start date
J

JOhn

is there a function that will let me convert a date from
US format, eg 03/23/2004, to european format, eg
23/03/2004?

Thanks in advance

John
 
My system is set to use the "European" format - also Canadian - so I
sometimes have the reverse problem.
If I want US format I just use Format|Cells|Date and select an appropriate
format
If there is not one you like, use a Custom format in for mm/dd/yyyy
 
Back
Top