additionally to the other answers: if we are talking about excel/openoffice here, in the import-dialogue you can choose the type of the fields, so here you'd have to choose Text'.