Sudden Problems with Excel formatting & Cell Protection RRS feed

  • Question

  • I suddenly have two problems with Excel 2007. 

    1) The cells in my workbooks are being protected without my desire, intent or instruction.  I don't know how to have the "normal" formatting where they are NOT protected unless specifcally chosen.

    2) Separately, the cells in my workbooks are suddenly formatted as [0.001 * x] where x is the input.  For example, if I input the number 4, the worksheet shows 0.004.  How can I get to the "normal" outcome of showing "4"?


    Thanks for your help!

    Wednesday, August 25, 2010 7:43 PM