formulas don,t work

[Kiss]

I received a database from another source
in cell c1 i enter =A1 and press enter nothing happens
it just abbears as =A1
No formulas are working
But in another worksheet in the same file all is ok

 

[Anne Troy]

Hi, Kiss. That's 'cause the cell is formatted as text. Try:
a) formatting it as general
b) Edit-->Clear-->All, save the file, and type the formula again
************
Anne Troy
www.OfficeArticles.com

 

[Max]

The sheet might have been formatted as text

Try this on a *spare* copy of the sheet

Select col C, press CTRL+SHIFT+Right arrow
(this will select all the cols C to IV)

Right-click on selection > Format Cells > General > OK

With the selection of cols C to IV still in-place:
Click Edit > Replace
Find what: = (enter an equal sign)
Replace with: = (enter an equal sign)
Click "Replace All"

The above should re-set things back to normal for cols C to IV

 

[Kiss]

Thank you very very much
all is well