Stop Excel from changing cell contents

Highlight the column. Right-click → format cells → custom → then choose a single 0.

Source: http://stackoverflow.com/questions/2420931/stop-excel-from-changing-cell-contents-ever