Mar 05 2022 08:37 AM
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 formula itself ?
Mar 05 2022 08:44 AM
@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 "=")
Mar 05 2022 08:47 AM
Start Excel and call up the desired document.
If you are working in the Office 365 version of Excel,
press the key combination (CTRL) + (Shift) and (´).
In older versions of the software you must use the combination (Ctrl) + (#).
After pressing the key combination once, you should only see the result again as usual and no longer the entire formula.
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
Mar 05 2022 08:52 AM
Mar 05 2022 09:07 AM
Hi Matt,
Mar 05 2022 09:11 AM
Mar 05 2022 09:11 AM
Mar 05 2022 04:30 PM
Mar 06 2022 03:59 AM
Mar 06 2022 09:42 AM