Forum Discussion
waynerenton
Aug 02, 2019Copper Contributor
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 $ ...
Twifoo
Aug 02, 2019Silver Contributor
Apply this custom number format to the cells for which you want to return nothing when the value is 0:
_($* #,##0.00_);_($* (#,##0.00);