+ Reply to Thread
Results 1 to 2 of 2

Number custom formatting

  1. #1
    Don
    Guest

    Number custom formatting

    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

  2. #2
    JLatham
    Guest

    RE: Number custom formatting

    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.

    "Don" wrote:

    > 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1