Custom cell format

[PATSYS]

How do I make the cell format in such a way that if the value is zero, what should appear is "-", if the value is negative, then it has to be with red font color, and if positive, just the normal font color. And all these with no decimals and with comma separator for thousands.

Thanks

 

[DominicB]

Good morning PATSYS

This format worked OK for me. Beware of typos, as you can't copy and paste into the custom format box - I think I've reproduced the format faithfully below - post back if you can't make it work :

[=0],"-";[Red][<1]#,##0;#,##0

HTH

DominicB

Edit : Slight correction

 

[Peter_SSs]

..perhaps this?
#,##0;[Red]#,##0;"-"
or
#,##0;[Red]-#,##0;"-"

 

[PATSYS]

Thanks guys, all your suggestions worked.