Detecting LOCALE of cell

ahennema

New Member
Joined
Sep 14, 2005
Messages
34
Office Version
365
Platform
Windows, MacOS
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,095,365
Messages
5,444,030
Members
405,261
Latest member
Khauff

This Week's Hot Topics

Top