Forum Discussion
Hiding the $ symbol when no amount in cell
Hello, Can someone please help me. I have a spreadsheet with formulas in and the $ symbol in multiple cells with no amounts in, for example $ 24.83 $ 75.00 $ ...
Apply this custom number format to the cells for which you want to return nothing when the value is 0:
_($* #,##0.00_);_($* (#,##0.00);