Custom number formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I think you are stuck with what you have. Your first section is formatting
all numbers <1000000, which of course would include all negative numbers, so
they will all be "Kbps". So only positive numbers >1000000 will be "Mbps".
Excel doesn't allow for any more conditions in custom formatting to take
this any further. Besides, if you are dealing with -bps then you have
discovered how to send data back into the past. I don't think Microsoft can
deal with that yet.
Just my $0.02

Mike F
 
Back
Top