Bad Export To Excel with $ sign or Thousand Separators

When I use setNumberFormat = ‘$0,000", 1, “.”, ",’ the downloaded Excel file has all zero values.

When I use setNumberFormat = ‘0,000", 1, “.”, ",’ the downloaded Excel file has decimal places instead of a comma and truncated the rest of the number on the right side.

I have tried making the change to gridExcelWrapper suggested in another post:

                                    case 'ron':
				$text = preg_replace("/[^\d-\.]/", "", $text);
				$this->excel->getActiveSheet()->getCell($this->getColName($i).$this->currentRow)->setValueExplicit($text, PHPExcel_Cell_DataType::TYPE_NUMERIC);
				break;  

This change did not help.

Got it working with suggested change, except no $ or Thousand Separators in the exported spreadsheet.