title: Currency value with provided symbol in excel cell using C# Excel library
body: <p>I am creating excel file using c#. I am different columns settings like number , currency , date etc . I am setting range of excel cell and proving custom Number format. But when I am setting currency it is showing wrong symbol in excel file. Here is my code for column settings</p>
  
  <pre><code>int row = 9;
  int index = 10;
  int count = Report.Data.Count - 1;
  for (int i = 0; i &lt; columns.Count; i++) {
   switch (columns[i].Type.ToUpperInvariant()) {
    case ColumnSettingType.Number:
     {
      oRange = (Excel.Range) oSheet.Range[oSheet.Cells[index, i + 1], oSheet.Cells[index + count, i + 1]];
      oRange.NumberFormat = "#,###,###";
      break;
     }
    case ColumnSettingType.Currency:
     {
      oRange = (Excel.Range) oSheet.Range[oSheet.Cells[index, i + 1], oSheet.Cells[index + count, i + 1]];
      oRange.NumberFormat = "$ #,###,###.00";
      break;
     }
    case ColumnSettingType.Percentage:
     {
      oRange = (Excel.Range) oSheet.Range[oSheet.Cells[index, i + 1], oSheet.Cells[index + count, i + 1]];
      oRange.NumberFormat = "0.00%";
      break;
     }
    case ColumnSettingType.Date:
     {
      oRange = (Excel.Range) oSheet.Range[oSheet.Cells[index, i + 1], oSheet.Cells[index + count, i + 1]];
      oRange.NumberFormat = "$#,###,###.00";
      break;
     }
   }
   oSheet.Cells[row, i + 1] = columns[i].ColumnName;
  }
  </code></pre>
  
  <p>My excel file is showing another symbol instead of <strong>($)</strong>, Also I need to show this symbol dynamically which I pass.</p>
  
  <p>Need help.</p>
  
  <p><a href="https://i.stack.imgur.com/ifvkQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ifvkQ.png" alt="enter image description here"></a></p>