# How to enter a literal string into a Libre Calc cell?

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.

edit retag close merge delete

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.

( 2020-08-02 09:32:00 +0200 )edit

Sort by » oldest newest most voted

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).

Check the mark () to the left of the answer that solves your question.

more

Hello,

format your cell as text (Format Code: @) before you enter data. This disables input recognition and enter +1/2 directly.

Hope that helps

more