Number custom 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
 
Your format statement says that if any number is less than 1,000,000 then
display as Kbps. All negative numbers are going to meet that criteria. You
need to be looking at the ABSOLUTE value of the cell without sign to get the
results you want. so then the absolute, unsigned value of -1344000 would
become 1344000 and would display as you want it to be.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom number formatting 1
Custom Format with multiple conditonals 1
Custom format applicable to negative and positive numbers? 5
Custom Cell Formats 2
Number format 1
custom number format 1
Changing Default Color in Custom Number Format 3
Concatenate in a Cell (&) and working with the numbers. 4

Back
Top