+ Reply to Thread
Results 1 to 7 of 7

Programing a column so all numbers entered in column cells will be negative

  1. #1
    Registered User
    Join Date
    04-21-2009
    Location
    Akron, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    7

    Programing a column so all numbers entered in column cells will be negative

    How do you program a column so all numbers in the column cells will be negative without entering the minus sign or brackets in each cell?

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Programing a column so all numbers entered in column cells will be negative

    Select the column and right click. Select "Format cells". Select Custom, and type in the box -0.00, press ok.

  3. #3
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365
    Posts
    963

    Re: Programing a column so all numbers entered in column cells will be negative

    Format Cells:
    Custom
    Enter this: -#,###.##

    Adjust for number of decimal places etc.

    Let us know if it behaves as intended.
    Pete

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Programing a column so all numbers entered in column cells will be negative

    I think you need VBA to do that.
    **** If you really wan't the values really negative

    Please advice if I am correct then we will move your thread to vba subforum.

    regards,
    vlady
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  5. #5
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Programing a column so all numbers entered in column cells will be negative

    Yes that's true, formatting cells just changes the way the number looks, it doesn't actually change the number. Either you need vba, or use a helper column, such as: =IF(A1="","",A1*-1).

  6. #6
    Registered User
    Join Date
    04-21-2009
    Location
    Akron, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Programing a column so all numbers entered in column cells will be negative

    I couldn't get suggestions #1 and #2 to work. What is VBA?

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Programing a column so all numbers entered in column cells will be negative

    Let say it is a Programming in excel.
    Formatting solutions in 1 and 2 will not give you a REAL negative numbers It is just formatting.
    Is your purpose to have REAL negative numbers? so you need VBA.
    Or Formulas with a Helper column
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-17-2009, 09:14 AM
  2. [SOLVED] Excel Formula - Add column of numbers but ignore negative numbers
    By view for Distribution List members in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2006, 10:20 PM
  3. [SOLVED] How do I change the plus to a negative in a column of numbers?
    By bj in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 PM
  4. [SOLVED] How do I change the plus to a negative in a column of numbers?
    By JKB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  5. [SOLVED] How do I change the plus to a negative in a column of numbers?
    By JKB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  6. How do I change the plus to a negative in a column of numbers?
    By JKB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  7. [SOLVED] How do I change the plus to a negative in a column of numbers?
    By JKB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  8. How to turn positive numbers in a column to negative numbers ?
    By Dbase Beginner in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 03:14 AM

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