Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Displays Instead of Result One Column Only
I have a spreadsheet where in one column only any formula I enter displays
as a formula and not as a result of the formula. In Tools | Options we do NOT have Formulas checkbox selected. Other columns in this spreadsheet resolve the formulas to values. In the one affected column the formula reads: =IF(H163=1099,"x","") What displays in the cell is the above formula as a string. What would cause a formula to not calculate a result for one column or cell only? -- W |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Displays Instead of Result One Column Only
If you're not looking at formulas, then the cells that are showing that formula
are (probably) formatted as text. You can fix a single cell by: Select the cell formatting the cell as General (or anything but Text) re-entering the formula (Hit F2, then hit enter) You can fix all the cells in a range by: Selecting the range (or column) Formatting the cells as General (or anything but Text) Edit|replace what: = (equal sign) with: = (equal sign) replace all On 02/06/2012 06:01, W wrote: I have a spreadsheet where in one column only any formula I enter displays as a formula and not as a result of the formula. In Tools | Options we do NOT have Formulas checkbox selected. Other columns in this spreadsheet resolve the formulas to values. In the one affected column the formula reads: =IF(H163=1099,"x","") What displays in the cell is the above formula as a string. What would cause a formula to not calculate a result for one column or cell only? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula displays instead of text result | Excel Discussion (Misc queries) | |||
Cell displays formula and not result | Excel Worksheet Functions | |||
Cell Displays Formula, not result | Excel Worksheet Functions | |||
Cell displays formula, not result? | Excel Discussion (Misc queries) | |||
Cell displays formula instead of result | Excel Discussion (Misc queries) |