Some cells in a sheet will not accept a simple = formula

  • Thread starter Thread starter Glenn Snyder
  • Start date Start date
G

Glenn Snyder

Hi. I have this wierd issue. When I open a new sheet
some of the cells won't accept a formula. I tried a
simple "=" formula from one cell with data to one of the
affected cells and it just comes back with reference info
(=sheet1, A3 that sort of thing).

It works fine when I use the fromat painter to copy the
formats from a "good" cell.

Any ideas?
 
Hi
probably the cell is formated as text. Try (prior to entering a
formula):
- select the cell
- goto 'format - Cells' and choose 'General' as format
 
Back
Top