Use an apostrophe before the text or formula-like entry to force text display
Example: `’ =SUM(A1:A3)` to show the formula as text
Example: `’123` to display 123 as text instead of a number
Format the cell as Plain text before entering the content
Use the TEXT function to convert a formula result to text
Example: `=TEXT(A1,”0″)`
If you want visible text before a formula result, concatenate text with the formula
Example: `=”Total: “&SUM(A1:A3)`
If you want only the formula to appear as text, enter it with a leading apostrophe
Remove any leading equals sign if you want Sheets to treat it as plain text
Use a space before the equals sign only if you want the entry to remain text in some cases