Menu
I am trying to add/prefix a plus sign "+" if the value is negative. e.g. +10
I have sheet where some bill payments are made and sometimes they overpay. So, the Balance column should reflect like +(over paid value).
I tried with =CONCATENATE but this does not help. It comes as +-10
=IF(C2<0,CONCATENATE("+",C2),"")
412
Select the first cell where you want to insert a plus or minus sign (e.g., C2). Then, in the Ribbon, go to Insert > Symbol.
Step 1: Select the range of cells that you want to shade with color green if the values are positive. The range of cells highlighted. Step 2: Go to Format > Conditional formatting. Click Format then click Conditional formatting from the drop-down menu.
You can try going to Format > Number > More formats > Custom number format and inserting the following expression: "-"0;"+"0;0
This will cause negative values to be show with a + sign, and positive ones to be shown with a - sign. The value that it holds, however, will still be the original one (as a number).
151
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
