Excel Problem - Corrupt cells / cells don't compute formulas

[worldwise]

Hi,

I have a problem with an Excel workbook. For the sake of this example, I have four worksheets: Hi,Hi2,Bye,Bye2

Worksheet Hi pulls some values straight from Hi2. Bye pulls some from Bye2. Yes I need them to be separate sheets.

The problem is that some of the cells in Hi and Bye do not compute or do anything with forumlas. So even if I type in "='Hi2'!A15" in cell C15 of worksheet Hi, nothing happens. The cell simply displays the formula literally. The same happens if I input "=5+5" or any other formula.

Formatting the cells as text, number, etc does nothing. Dragging and dropping the equation from cells that are working properly does nothing. I have already went to Tools->Option->Calculation and made sure it was on 'Automatic'.

Again, its only some cells that have this problem. Other cells displays the correct information taken from the other worksheet.

Please let me know how to fix this. Re-doing doing the Workbook is not really an option.

Thanks.

 

[CBasicAsslember]

If you change the formating from text to general the formula in the cell will still display as text. If you press the = sign in the formula bar it will convert it.

 

[worldwise]

I was half way there. I re-formatted the cell but figured the equation would compute automatically but I guess not.

Thanks!!