formula creating itself

  • Thread starter Thread starter Paolo
  • Start date Start date
P

Paolo

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!!!!!!!!!!
 
Click on Tools | Options | Edit tab and uncheck the option for Extend
list formats and formulas, then click OK.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with a function that calls itself 3
copying groups with formulas 5
Formula help 1
Copying Formulas Between Worksheets 2
Copy and Pasting Formulas 4
Why did auto calculate suddenly change to manual calcu... 4
Formula showing zero's 12
Formula 2

Back
Top