Formatting Excel Cell (custom format)

Hi All,

I am trying to accomplish the following when formatting an Excel cell:

Number less than 10 -> 2 decimal places
Number greater than 10 -> no decimal places
Zero -> two dashes (i.e --)

I have the following format that I put into the custom cell format, but it doesn't seem to work for the zero:

[<10]$0.00;$#,###

Many thanks!

Works like a charm. Many thanks!