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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
This might be something you have already thought of, bu tht ething that keeps
catch me out is forgetting to put the "=" in front of the formula - that stays as text. Otherwise check the settings under tools-Options-View-Window options - "Formulas" should not be checked. Victoria "Jerry Bennett" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
Hi,
If the cell was preformatted as text then yes the formula will appear rather than the result, you need to format the cells as General or other depending on the result you want, but just formatting the cell will not work you need to re-enter the formula by selecting the cell and hitting F2 then ENTER, if you have a whole column like this then a faster way is to select the column then go to DATA/Text to column, NEXT, NEXT and FINISH... this method only works if you select consecutive cells in a column, will not work with rows. HTH Jean-Guy "Jerry Bennett" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
I would check to see if the cell is formatted at text? If this is the case,
you should change the format (ex Generic) and your results should be different. You may have to recopy. "Jerry Bennett" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
thank you for writing Victoria, = sign not the problem; i don't know where
"tools" is; i am using excel 2007, so maybe you are referring to 2003. If this is so, where do i go in 2007, if you know? Or, if you are using 2007, maybe a more detailed instruction as to where i find 'Tools"? thanks -- Jerry "VJP" wrote: This might be something you have already thought of, bu tht ething that keeps catch me out is forgetting to put the "=" in front of the formula - that stays as text. Otherwise check the settings under tools-Options-View-Window options - "Formulas" should not be checked. Victoria "Jerry Bennett" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
Another way is to format the cells as general then do editreplace and
replace = with = that will trigger a calculation and convert the formulas -- Regards, Peo Sjoblom "pinmaster" wrote in message ... Hi, If the cell was preformatted as text then yes the formula will appear rather than the result, you need to format the cells as General or other depending on the result you want, but just formatting the cell will not work you need to re-enter the formula by selecting the cell and hitting F2 then ENTER, if you have a whole column like this then a faster way is to select the column then go to DATA/Text to column, NEXT, NEXT and FINISH... this method only works if you select consecutive cells in a column, will not work with rows. HTH Jean-Guy "Jerry Bennett" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
Make sure the cell or column is formatted as "General" before entering
the formula. If the formula is already there, format as "General", then hit F2 on the cell, and hit enter, it should convert to a formula. HTH, JP On Nov 9, 9:38 am, Jerry Bennett wrote: 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 |
Reply |
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) |