Aug 02 2019 02:38 AM
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 | $ 99.83 |
$ - | $ - | |
$ - | $ - |
How can I hide the $ symbol until there is an amount in the cell.
Thanks in advance
Aug 02 2019 03:03 AM
Apply this custom number format to the cells for which you want to return nothing when the value is 0:
_($* #,##0.00_);_($* (#,##0.00);