Set the column/cell format to “text” and it will retain what you typed.