Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas showing up as text
I have read previous bulletins about this where after entering a formula
(starting with an "=" sign, it shows up as text versus the result. I have done the following: 1) Checked to see if the ToolsOptionsView box is unchecked. 2) Verified the format to make sure it is listed as a number (though it should still be allowed to be text). 3) Taken a different cell, entered "=1+2" (of course, without quotes) to make sure that the result is "3" and copied it into the cell i'm having an issue with (and it gives me the result of "3"), I have then formated it to text and still get the "3" result. But then, when I make a change to put in the formula I need, it just shows up as text, starting with an = sign. 4) I've tried to copy and paste the whole worksheet into a new worksheet (so that the defaults are there) but that doesn't work. I have found a work around, which is to do a 'replace' when the cell gives me the formula, but this is a huge pain in the neck and is taking me way too long. It is also giving me very little confidence that the error won't appear at some time in the future. I have also found that I can take some formulas that are requesting a blank/" " to show up in the cell (versus a 0) so that it doesn't get counted with my COUNTA formula, but in some cells it shows as a blank, and others as a zero 0. Again, with me verifying the format of the cell and even cutting and pasting from one that works. PLEASE HELP ME! THANKS IN ADVANCE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel considers my formulas as plain text | Excel Worksheet Functions | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Text and Function Formulas | Excel Worksheet Functions | |||
HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? | Excel Worksheet Functions | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |