Dash instead of zeros, still display by thousands

[cluelessintern]

Hello,

I need to keep my numbers in thousands (ie. 456,798 as 456.798 or 7,000 as 7). In addition I need to have all cells that equal zero be displayed as dashes "-". How do I format my cells?

Thanks!

 

[DLB20720]

I'm not aware of any formatting method but if you can use an equation, this would work assuming your '456,798' number is in cell A1. =IF(A1>0,A1/1000,"-")