I am importing some tennis stats with the "get external data" function in Excel for mac. All the stats come in nicely into excel, except 2 columns. Cell C3 should show Win Loss record of "14-2" but shows "14MFeb".
I have tried to change the format of the cells, but nothing works. When I import the same file into Open office, everything is perfect, even the Win Loss columns? I am thinking this must be something with the language settings in Excel for mac, but don't know how to fix it.
Any help much appreciated.