+ Reply to Thread
Results 1 to 3 of 3

negative numbers w/o negative sign

  1. #1
    Registered User
    Join Date
    05-30-2009
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    1

    negative numbers w/o negative sign

    OK, im working on a school project and it is to make a checkbook register with the common credit and debit columns. We are given the values to enter and supposed to make the debit column show in parentheses and in red automatically, without entering a - in front of the entries. I cannot use the number dialog box as I dont have - in front, only tip teacher gave is use a formula at top of column.
    example of debit entry 124.18, no - sign, no dollar sign.
    please help, im going insane.
    excel 2007

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: negative numbers w/o negative sign

    Format > Cells, Number tab, ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    04-03-2007
    Location
    Auckland, New Zealand
    MS-Off Ver
    2007
    Posts
    137

    Re: negative numbers w/o negative sign

    Hi,

    Excel number format syntax is:

    Positive Numbers ; Negative Numbers ; format for Zero values; format for text
    --- Note the semi-colon, this separates the different formats for each value type---

    So,
    If you want to fomat negative numbers with parenthesis and coloured RED
    Right click on a cell you want to format.

    From the pop-up mouse menu select Format Cells.
    On the "Numbers" tab select 'Custom'
    On the righthand side of the of the tab you'll see a list of formats with one directly under the word 'Type:'

    Click into this, highlight by dragging the mouse and type in for following.

    #,###.#0;[RED](#,###.#0);-;

    This will give you:
    Positive Numbers with two decimal places and thousands separated with a comma
    Negative numbers encapsulated in parenthesis and coloured RED, with two decimal places and thousands separated with a comma
    Zero values will be shown with a dash (or minus sign) to show that the cell is not empty,

    When you've time go to Excel Help and search for 'Custom Number Formats' - very useful.


    Hope that helps

+ 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