+ Reply to Thread
Results 1 to 4 of 4

Custom format cells - how to make it say < number

  1. #1
    Registered User
    Join Date
    02-16-2006
    Posts
    2

    Custom format cells - how to make it say < number

    Hi, I have a tiny question for you...

    You know that one can get for example the format "percent" in a cell so if I write 8, 8% will turn up in the cell. I would like to do the same but with < so if I write 0,1 the cell will say <0.1. The only number in the cell have to be 0.1 so I can use these numbers to make diagrams and calculate etc. I have looked at the custom category on Format Cells under Format but I can't come up with a format code that gives the wanted result. So please, can anyone give me help on this....

    Thanks!
    /liniis

  2. #2
    Bob Phillips
    Guest

    Re: Custom format cells - how to make it say < number

    Is this what you mean

    [<0]<0.0;General

    --

    HTH

    Bob Phillips

    (remove nothere from the email address if mailing direct)

    "liniis" <liniis.23bg4y_1140083101.9387@excelforum-nospam.com> wrote in
    message news:liniis.23bg4y_1140083101.9387@excelforum-nospam.com...
    >
    > Hi, I have a tiny question for you...
    >
    > You know that one can get for example the format "percent" in a cell so
    > if I write 8, 8% will turn up in the cell. I would like to do the same
    > but with < so if I write 0,1 the cell will say <0.1. The only number in
    > the cell have to be 0.1 so I can use these numbers to make diagrams and
    > calculate etc. I have looked at the custom category on Format Cells
    > under Format but I can't come up with a format code that gives the
    > wanted result. So please, can anyone give me help on this....
    >
    > Thanks!
    > /liniis
    >
    >
    > --
    > liniis
    > ------------------------------------------------------------------------
    > liniis's Profile:

    http://www.excelforum.com/member.php...o&userid=31615
    > View this thread: http://www.excelforum.com/showthread...hreadid=513105
    >




  3. #3
    Registered User
    Join Date
    02-16-2006
    Posts
    2

    Can't get it to work

    ...do you mean that I should write this in the custom category in the "number" tab under "format cells"? I have tried that but excel returns a warning sayin that Excel cannot use the number format I typed.
    LMK...
    /Liniis

  4. #4
    Bob Phillips
    Guest

    Re: Custom format cells - how to make it say < number

    I mean in the Custom selection of Format>Cells

    --

    HTH

    Bob Phillips

    (remove nothere from the email address if mailing direct)

    "liniis" <liniis.23cd0a_1140125714.2558@excelforum-nospam.com> wrote in
    message news:liniis.23cd0a_1140125714.2558@excelforum-nospam.com...
    >
    > ..do you mean that I should write this in the custom category in the
    > "number" tab under "format cells"? I have tried that but excel returns
    > a warning sayin that Excel cannot use the number format I typed.
    > LMK...
    > /Liniis
    >
    >
    > --
    > liniis
    > ------------------------------------------------------------------------
    > liniis's Profile:

    http://www.excelforum.com/member.php...o&userid=31615
    > View this thread: http://www.excelforum.com/showthread...hreadid=513105
    >




+ 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