#formula-showing-as-text

Excel Formula Showing as Text Instead of a Result

When a formula shows as text, check Show Formulas, a leading apostrophe or space, and pasted content. In Excel, a Text format can also be the cause.