1
Answer

Zero to dash in Excel using C#

Feroz Khan

Feroz Khan
2y
626
1

Dear All,

How can i set in excel file custom format in cells if there is Zero value should be (-) below i am trying but not working.

xlWorkSheet.Cells["L5", "AB49"].SetFormat = "_(* #,##0.00_);_(* (#,##0.00);_(*  '-' ??_)_(@_)";

 

Please yours support.

 

Answers (1)
Next Recommended Forum