I have data in an Excel file that I want to join with a shapefile in my project. The Excel file contains values like volumes. The Excel file and the shapefile I want to join it with both contain the same property names.
The problem is, when I join the two, I get too many decimals in the attribute table. I get six, but I only want it to be one.
I tested to change the format of the cells to one decimal, and then I saved the file as *csv. But, somehow I seem to loose data in the process? It should be 42 rows that contains data in the column i am working with, but I end up with only like 10?
Another thing is that my property names contains the letters Å. Ä and Ö, perhaps this complicates things?
I read the question How can I change the precision in the attribute table?, but it doesn't mention the problem with the data loss.
My question was tagged with qgis, but I didn't write what version I'm using. I use QGIS 2.2.0. Would it help to upgrade to the latest version?