1. change the cell format of the whole column to "text" 2. do your text2column 3. change back to whatever format you want.