Feroz Khan

Feroz Khan

  • 1.4k
  • 300
  • 92.4k

Zero to dash in Excel using C#

Aug 9 2022 4:37 PM

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)