Issue while exporting dataset to excel

Question

Hi,
I have a dataset and i want to export it to excel. Problem is while one of the datacolumn contains negative value and i want that column value to be shown in brackets in excel.

In the dataset (datatable view) its getting displayed correctly. i.e. (21,000) 

But in the excel, its ccoming as -21,000 but i want it in (21,000) format. Here is the piece of code which i am using...

*********************
   HttpResponse response = HttpContext.Current.Response;
  response.Clear();
  response.Charset = string.Empty;
  string filename = "test.xls";
  response.ContentType = "application/vnd.ms-excel";
  response.AddHeader(Constant.CONTENT_DISPOSITION, "attachment;filename=\"" + filename + "\"");
 
  using (StringWriter sw = new StringWriter())
  {
  using (HtmlTextWriter htw = new HtmlTextWriter(sw))
  {
  System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();
  dg.Font.Name = "verdana";
  dg.Font.Size = 10;
  dg.HeaderStyle.Font.Bold = true;
  dg.HeaderStyle.ForeColor = Color.SteelBlue;
  dg.DataSource = DATASET;
  dg.DataBind();
  dg.RenderControl(htw);
  response.Write(sw.ToString());
  response.End();
  }
  }



**********************

Please suggest something...
Thanks.