[<1000]0-00;00-000 for 1-22 and 12-434

I picked up the above solution from another thread. Then I created my own test.

I tested with

0-00;00-000 and
00-000;0-00 respectively.

No [<1000] for both.

Without the condition [<1000], it will always pick up the *first* format regardless of how many digits we key or how many formats we have. That's just the way it is, right? For number formats, it will pick up the right format depending on whether the number is positive or negative. We have to enter the formats in a specific order for positive, negative etc.

Is there a good link that I can use to learn more about custom format?

Thanks.

Epinn