+ Reply to Thread
Results 1 to 2 of 2

number formats that allow you to format the appearance of negativ.

  1. #1
    jassmon
    Guest

    number formats that allow you to format the appearance of negativ.

    I don't understand what it means to List two number formats that allow you to
    format the appearance of negative numbers using parentheses?

  2. #2
    Nick Hodge
    Guest

    Re: number formats that allow you to format the appearance of negativ.

    Jasmon

    There are up to four parts to a format in Excel, separated by ;, so

    FormatForPositive;FormatForNegative;FormatForZero;FormatForText

    So if you want two decimals and parenthesis for negatives, you could use

    0.00;(0.00);0.00

    Notice you don't need one for text so I have not included it. If you miss a
    format type then you should still include it's separator

    0.00;;0.00

    Has only set a format for positive numbers and zeroes.

    You could check help for all the options available in formatting codes and
    perhaps read here

    http://www.nickhodge.co.uk/gui/formatmenu/cells.htm

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


    "jassmon" <jassmon@discussions.microsoft.com> wrote in message
    news:2ECC0595-C465-4D56-956A-54B25B1108D4@microsoft.com...
    >I don't understand what it means to List two number formats that allow you
    >to
    > format the appearance of negative numbers using parentheses?




+ 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