Dec 20 2022 08:56 AM
It looks like there is a bug in Data Types, Geography, in Excel. If I write in a sheet
Italia |
Francia |
Inghilterra |
Germania |
Paesi Bassi |
Spagna |
Portogallo |
Grecia |
that is, the Italian names of Italy, France, England, Germany, Nederland, Spain, Portugal, and Greece, I select all of them and then I mark them as Geographic data, Excel recognize all of them but England and Spain.
However, if I use UK instead of Inghilterra and Spain (in English!) instead of Spagna, that is
Italia |
Francia |
UK |
Germania |
Paesi Bassi |
Spain |
Portogallo |
Grecia |
Excel recognizes those two too, and change them to Regno Unito and Spagna. The strange behavior is that it uses Spagna as I did before, but only if I write Spain.
Any idea why?