This question already has an answer here:
I have imported a .csv file containing unique identifiers with two decimal places (e.g. 53500001.00, 53500001.01 etc.). I am joining this file to a vector file with the same identifiers. However, when I import the .csv file the identifiers ending with .00 have been reduced to integers in the attribute table and the join returns null values in those instances.
It is census data so I can't go back through and manually change this as it's hundreds of thousands of lines. Is there a way to change the precision of the attribute table similar to in excel?