The problem is how excel handles the typing of cells. Excel essentially reads the first 10 cell values, and then guesses at the data type. When you see this happening, best practice is generally to select the entire column (just the cell won’t work usually) and change the cell format type to text. However, sometimes that doesn’t work. And when it doesn’t, you have to use the Text to Column function. Here’s the screenshots.