View original (French)

EXCEL - Show the + signs

Solved
bibidel Posted messages 19 Status Member -  
 Hasna -
Hello,

It's me again...
How to : DISPLAY THE PLUS SIGN FOR A POSITIVE RESULT OF A FORMULA???
Thank you for your help.
Bibidel
Configuration: Windows XP Internet Explorer 6.0

2 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello bibidel,

    You can define a custom format like +Standard;-Standard
    before the ; it's the format for positive numbers, after the ; it's for negative numbers
    and you can add a format for 0 like +Standard;-Standard;0

    eric
    82
    1. super_b
       
      Great, thanks!!
      5
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Good evening,

      - right-click on the selected cell or range, choose 'format cells'
      - in the 'number' tab, select the 'Custom' category at the bottom of the list
      - in Type enter: +Standard;-Standard;0

      eric
      1