Hi all,

I am trying to format a number that can be in the range + or - xxxxxx.
I have formatted such that it reads:
[<1000000]0.00,"Kbps";[=1000000]0.00,,"Mbps";General
The formatting works for all positive values (eg 9394000 is output as
9.39Mbps, 128000 is output as 128.00Kbps). I cannot however get the negative
values formatted correctly? -192000 is output as -192Kbps which is correct,
but -1344000 is output as -1344.00Kbps instead of -1.34Mbps?

I suspect the issue is very trivial - but cannot locate : (
Help really appreciated!

Thx,

Don