Calc: Display exact input in cell if not a formula

[lurgold]

I am wondering if there is a way to format cells to display the exact input I’m putting in unless it is a formula?

So, I have a block of cells that is usually filled with a formula. Sometimes, I do want to manually put in values and just want that value to be displayed. However, the input is not necessarily a number, but something like “8+” or “9-10”, which conflicts with all of the formatting options I have found (Except for text, which in turn suppresses formulas).

All of the formulas output decimal numbers, if that helps and/or makes a difference.

Thanks for the help!

[mikekaganski]

Start non-formulas with apostrophe ', which is another way to say “this is a text”, like

'8+
'9-10

[Villeroy]

Add a leading apostrophe. Like the leading = indicates a formula, the leading apostrophe indicates literal text. It won’t be part of the text. Input '0123 yields the text 0123 rather than number 123.