This project has moved and is read-only. For the latest updates, please go here.

Format cell as currency

Jul 21, 2010 at 2:38 PM

Hi all,

I am not using any excel template.

am creating a excel from scratch.

but i want format a cell to currency.

i can convert it in to number but i cant convert it into currency.

please i need solution to implement it.

its very urgent please.

Thanks in advance.






Jul 21, 2010 at 4:16 PM
cell.Style.Numberformat.Format = "#,##0.00 €;-#,##0.00 €";
I suppose you'll have to change the € for your currency sign or something...
Jul 22, 2010 at 5:44 AM

no its not changing to currency but its changing to custom.


please help me in it.