or format all the cells in that column(s) or row(s) to TEXT before entering your data.

ChemistB