Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
I have this problem over and over, in 2003 and 2007; sometimes if i change a
formula, the formula will appear then in the cell as text instead of the value or string calculated by the cell, and i cannot get it to change, unless i copy the original formula from another cell in the same column. Or, even worse, sometimes whole columns will not accept formulas of any kind, they will just display the formula in the cell as text. In that case i have to delete the whole column and insert a new one and then it is ok. What gives? Can i fix this? Thanks -- Jerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text not appearing as typed in Excel | Excel Discussion (Misc queries) | |||
Cell format with Data Import (date appearing as text) | Excel Discussion (Misc queries) | |||
Full Text is not appearing in column | Excel Discussion (Misc queries) | |||
Hidden Cells Keep Appearing | New Users to Excel | |||
Why is my cell text not appearing? | Excel Discussion (Misc queries) |