title: Concatenate TEXT, format only parses positive numbers
body: <p>I want to concatenate three different cells into one to make a nice table presenting average and maximum value and the number of observations as follows:</p>
  
  <p>1.234 - 3.456 ( 7 )</p>
  
  <p>I found a way to do this, probably not the most efficient but still. However the only downside is that there are also negative numbers, which are for some reason ignored.</p>
  
  <p>The formula I use is the following:</p>
  
  <pre><code>=IF(R[-24]C&gt;1;CONCATENATE(TEXT(R[-8]C;"#,##0;;@")&amp;" - "&amp;TEXT(R[-16]C;"#,##0;;@")&amp;" ( "&amp;R[-24]C&amp;" )");CONCATENATE(TEXT(R[-16]C;"#,##0;;@")&amp;" ( 1 )"))
  </code></pre>
  
  <p>So my question would be, is there something I'm doint wrong with "#,##0;;@" or is there some error in my concatenate?</p>