Menu Tools|Options, Error Checking tab, uncheck the ones that annoy you....
I uncheck: Inconsistent Formula in region, Formula omits cells in region,
unlocked cells containing formula, and formulas referring to empty
cells....my personal preference (oh, and Number stored as text!).