title: How Can I set dynamic number format with separator in laravel excel maatwebsite?
body: <p>I have an amount column and I want to set integer format when the number does not have a decimal and double format when the number has a decimal. in both ways, I want to add separators to numbers.
  currently, I use bindValue but excel cells don't know the amount column as number format and I should select them and convert them to numbers.</p>
  <pre><code>public function bindValue(Cell $cell, $value)
  {
      if (is_int($value)) {
          $cell-&gt;setValueExplicit($value, '#,##0');
  
          return true;
      }else if (is_double($value)) {
          $cell-&gt;setValueExplicit($value, '#,##0.00');
  
          return true;
      }else{
          $cell-&gt;setValueExplicit($value,  DataType::TYPE_STRING);
  
          return true;
  
      }
  }
  </code></pre>
  <p><a href="https://i.stack.imgur.com/PU53N.png" rel="noreferrer"><img src="https://i.stack.imgur.com/PU53N.png" alt="enter image description here" /></a></p>
  <p>how can I fix it?</p>