ah, it's because I was inserting the data just by pasting it on top of a cell rather than pasting/typing it manually into the cell. idk why this is so and I have to double click to get in there the right way, but just pasting should accomplish the same thing. oh well.