I can see why that would be annoying but it's a tradeoff between how many people would find the automatic categorization of a cell useful vs how many would find it a nuisance. I'm not a spreadsheet wiz but I'm pretty sure it would allow you to set a column to interpret input as raw text.