Hi I was looking information about currency formatting the cell columns. When I specify the currency format of my column (myCell.CellFormat.FormatString = "$0.00") this does not seem to work because i open my excel file with office 2010 and the cells of my column did not have the correct currency format .
Thanx
Hi there,
shouldn't you specify the format string this way "$ {0}"? I may be able to better help you if you can post the sample code.
Thanks,
Lubomir
Hi
Sorry to jump in.
I have similar problem to display a currency value on the Excel.
Here is the code. The Excel output is still a string. Thanks in advance for your help.
WorksheetCell c;
c.Value = "93493.34"; // any positive/negative number
c.FormatString = "${0}";
I worked it out myself.
c.Value = 93493.34; // can't be string
c.FormatString = "$ ###,###,##0.00";