Click on Tools | Options | Edit tab and uncheck the option for Extend
list formats and formulas, then click OK.

Hope this helps.

Pete

On Jul 2, 12:54*pm, Paolo wrote:
I have a workbook with several different formulas. In one section the are
cells that contain formulas which do certain things according to what day it
is. Cells w20 through w26 have formulas w27 through w30 have no formulas.
When a value is input into o20 through o30, w27 - w30 suddenly have a formula
in them and it is the same format as the cell above it. These cells are
supposed to be empty and that is how I created them but these formulas keep
inserting themselves. Can anyone please help!!!!!!!!!!