Converting european date format to US format.

  • Thread starter Thread starter Alberto Martinez
  • Start date Start date
A

Alberto Martinez

I get a report from europe with date format 13-01-2012 00:00:00 . I tried simply formmating it to US format, but it only applies it to the first 12 days of each month. All help is greatly appreciated.
 
Hi Alberto,

Am Mon, 5 Aug 2013 08:51:18 -0700 (PDT) schrieb Alberto Martinez:
I get a report from europe with date format 13-01-2012 00:00:00 . I tried simply formmating it to US format, but it only applies it to the first 12 days of each month. All help is greatly appreciated.
Click to expand...

did you try custom number format
mm/dd/yyyy hh:mm:ss AM/PM

Regards
Claus B.
 
Hi Alberto,



Am Mon, 5 Aug 2013 08:51:18 -0700 (PDT) schrieb Alberto Martinez:






did you try custom number format

mm/dd/yyyy hh:mm:ss AM/PM



Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
Click to expand...

I did, but it also just applied to the first 12. For some reason when excel gets to day 13 of any month it no longer reads that cell as a date format even if I manually format it.
 
Back
Top