title: How to prefix Plus sign "+" before the number if the value is negative in Google Sheets or MS Excel?
body: <p>I am trying to add/prefix a plus sign "+" if the value is negative. e.g. <strong>+10</strong></p>
  
  <p>I have sheet where some bill payments are made and sometimes they overpay. So, the Balance column should reflect like +(over paid value).</p>
  
  <p>I tried with <code>=CONCATENATE</code> but this does not help. It comes as <strong>+-10</strong></p>
  
  <pre><code>=IF(C2&lt;0,CONCATENATE("+",C2),"")
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/UgwfA.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/UgwfA.jpg" alt="enter image description here"></a></p>