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

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

"Kiss" wrote in message
...
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

You might try making sure the columns are formatted as you want
and then running the macro TrimALL to essentially reenter
each cell. There is more description there to tell you how to find
what you actually had by using a few tests. But the macro will
remove leading and trailing spaces after converting CHAR(160)
to a regular space. If the data came from a web page then that
probably will fix the problem.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Anne Troy" wrote in message ...
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

"Kiss" wrote in message
...
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

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Kiss" wrote in message
...
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

Thank you very very much
all is well

"Kiss" wrote:

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