How to enter e.g.
+1/2
…into a cell as a literal string, so that it doesn’t get automatically replaced with a formula, but without formatting the cell as text? Normally, one would expect:
'+1/2
…to work (in Excel it does) but in this case it doesn’t.
If the program converts plain +1/2 into a formula, and treats '+1/2 as a string '+1/2, not +1/2, then this is a bug. Program must treat 'somestring as somestring when plain somestring will be treated as special string. Please file it.
Hello,
format your cell as text (Format Code: @) before you enter data. This disables input recognition and enter +1/2 directly.
Hope that helps
If you type '+1/2, you will see '+1/2.
You can type " +1/2" preceding the + with a space (double quotes here are only to show the space), but this will change alignment one space to the right.
Also can use ="+1/2"and will see +1/2 left aligned as text; but this is a formula (double quotes here are mandatory).
Use a text editor, type there +1/2, then copy and paste in the cell. As long as it doesn’t start with = it will show as text, while the cell format will remain as number standard. Also can do it with Writer, but will need to choose menu Edit-Paste Special-Paste Unformatted Text (same that Ctrl+Alt+Shift+V).
Edit your question if you want to add more information (Add Answer is reserved for solutions).
Check the mark (
) to the left of the answer that solves your question.