Anyone good at custom format? Please help

[Kaneszc]

How to create custom format for the following:
1. For numbers less than or equal to -1, display no decimal
2. For numbers greater than -1 and less than -1, display one decimal
3. For nubmber greater than or equal to 1, display no decimal
4. For 0, display "-"

I can accomplish the first 3 conditions by: [<-1]-#;[<1]0.#;#; , but Excel won't let me add more conditions.

[#2]

@Kaneszc 

Maybe, instead of seeing custom formatting as the solution, you could use the ROUND function embedded in an IF conditional. ROUND lets you specify the number of decimal places.

Try playing around with that combination a bit.

[#3]

@Kaneszc 

Excel supports maximum two logical conditions in custom number format. If more, you may use conditional formatting.