I do not know how to place a format unless something is in the cell.
If you have a zero in each cell instead of a blank, you could use the Accounting Number format without a dollar sign and that would show a "-" for each zero.
Accounting Number format without a dollar sign looks something like this:
Thank you!
jonathan92591 8 months ago
You are welcome!
ExcelIsFun 8 months ago
what if i wan2 have a centre formatted "-" in place of a blank?
khurram87 2 years ago
I do not know how to place a format unless something is in the cell.
If you have a zero in each cell instead of a blank, you could use the Accounting Number format without a dollar sign and that would show a "-" for each zero.
Accounting Number format without a dollar sign looks something like this:
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
ExcelIsFun 2 years ago