Comment by countmora

If you import with PowerQuery you can explicitly specify the data type for each column.