Converting european date format to US format.

  • Thread starter Alberto Martinez
  • 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.
 
C

Claus Busch

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.

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

Regards
Claus B.
 
A

Alberto Martinez

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top