Can someone please help me.
I have a spreadsheet with formulas in and the $ symbol in multiple cells with no amounts in, for example
How can I hide the $ symbol until there is an amount in the cell.
Thanks in advance
Apply this custom number format to the cells for which you want to return nothing when the value is 0:
_($* #,##0.00_);_($* (#,##0.00);