Forum Discussion
where is the result ?
just created a new spreadsheet. When entering formulas in a cell, the result does not appear in the cell, just the formula. What must I do to have the result of the formula appear rather than the f...
Stanger6804 First make sure Formulas -> Show Formulas isn't turned on:
If it is (like shown above) then click it off.
Next make sure the cell isn't set to TEXT:
Set it to GENERAL instead
next make sure their aren't any special characters at the beginning.
After doing the above, click in the cell and retype (at the very least deleting the "=" and anything before is and retyping that "=")