Hi,

There are 4 related questions:-

- Is it possible to combine [] conditions in a number format string? e.g
[=1000000][$$-409]
- If there are multiple [] conditions, is the order of precedent from left
to right?
- Is the maximum number of format fields 4? i.e., it's normally Positive;
Negative; Zero; Text
- What happens to the other format fields if I use the first two up with
[=1000000] <some formating text; [=1000] <some formatting text?

The reason I'm asking the questions, is that I'm trying to construct a
function that will format numbers in the form;

$ 1M (for numbers <= 1,000,000)
-$ 100K (for numbers between 1,000 and 1,000,000
$ - (for zero)

I have the additional challenge of repeating for ‚¬, Â¥ & £

Best regards


Mark