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.
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.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vishal YelvePosted Aug 10, 2022, 5:37 AM