I discovered the problem. On the Tools>Options>trasnition tab there is a check off for "transition formula entry".

If this is checked, everything entered on a sheet is automatically interpreted as a mathmatic formula.