View original (French)

EXCEL - Show the + signs

Solved
bibidel Posted messages 19 Status Membre -  
 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 réponses

Réponse 1 / 2
eriiic Posted messages 24581 Registration date   Status Contributeur 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
super_b
 
Great, thanks!!
5
eriiic Posted messages 24581 Registration date   Status Contributeur 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