1
Answer

Zero to dash in Excel using C#

Photo of Feroz Khan

Feroz Khan

2y
696
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)