I've had success getting rid of the scientific notation by just widening the column. Maybe that doesn't work all the time, I don't know.