Home / ubuntu / Questions / 1379739
In Process
Tarass
Asked: 2021-12-08 09:30:08 +0800 CST

How to display number + sign in in character chains

  • 772

I try to display the + sign of the number in the following character chains in G3 I want to see (-4)+(+4)= :

enter image description here

libreoffice

2 Answers

  1. You can define your own cell format

    1. Right click on the cell B3 and select Format Cells.... The Format Cells window will open.
    2. Under Category, select user defined
    3. In the Format Code box enter "+0;-0;0" without the quotes.

    As shown in the picture below:

    enter image description here

    Use the same cell format in other cells where you need it. The new format will be saved with this file. You may have to define it again for another file.

    To show the plus sign in the formula in the cell G3 above enter number format inside the formula as:

    ="("&TEXT(A3,"+0;-0;0")&")+("&TEXT(B3,"+0;-0;0")&")="

    Reference: https://help.libreoffice.org/latest/gu/text/shared/01/05020301.html?&DbPAR=WRITER&System=UNIX

    Hope this helps

    • 2

  2. On solution is to use TEXTE(B3;"+#;-#;0") :

    enter image description here

    • 0