Format cell as currency

Jul 21, 2010 at 1: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 3: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 4:44 AM

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

 

please help me in it.