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.
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.
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.