currency formatting cell | Infragistics Forums

currency formatting cell

frank posted over 13 years ago

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

245

Jun posted over 13 years ago in reply to Jun

I worked it out myself.

WorksheetCell c;

c.Value = 93493.34; // can't be string

c.FormatString = "$ ###,###,##0.00";
Cancel
Reply

Cancel
245

Jun posted over 13 years ago in reply to Lubomir Toshev

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}";
Cancel
Reply

Cancel
3726

Lubomir Toshev posted over 13 years ago

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
Cancel
Reply

Cancel