Hiding the $ symbol when no amount in cell

Copper Contributor

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

1 Reply

@waynerenton 

Apply this custom number format to the cells for which you want to return nothing when the value is 0: 

_($* #,##0.00_);_($* (#,##0.00);