Hi,
I used Adobe Acrobat to convert PDF files to Excel files. When I open the file it looks good, including the column of dates. However, when I sorted by date I get a mess. It turns out that many, but not all, of the the dates are in Afrikaans. So although the cell displays 04/12/15 (April 12 2015 to me) Excel reads it as (15/12/04). If I FORMAT that cell and change it from Afrikaans to English then I 12/15/04. It looks good but is the wrong date.
Is there a way to convert 04/12/15 in Afrikaans to 04/12/15 in English? Also, is there a way to detect which language Excel thinks it is in and then convert it. Since about half my cells are correctly identified as English and half are not I seem to be in a real mess.
P.S. Anybody have this problem with Adobe Acrobat Reader DC? IS there a better program?
Thanks,
Arich
I used Adobe Acrobat to convert PDF files to Excel files. When I open the file it looks good, including the column of dates. However, when I sorted by date I get a mess. It turns out that many, but not all, of the the dates are in Afrikaans. So although the cell displays 04/12/15 (April 12 2015 to me) Excel reads it as (15/12/04). If I FORMAT that cell and change it from Afrikaans to English then I 12/15/04. It looks good but is the wrong date.
Is there a way to convert 04/12/15 in Afrikaans to 04/12/15 in English? Also, is there a way to detect which language Excel thinks it is in and then convert it. Since about half my cells are correctly identified as English and half are not I seem to be in a real mess.
P.S. Anybody have this problem with Adobe Acrobat Reader DC? IS there a better program?
Thanks,
Arich
