formulas don,t work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top