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?
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?
Select the column and right click. Select "Format cells". Select Custom, and type in the box -0.00, press ok.
Format Cells:
Custom
Enter this: -#,###.##
Adjust for number of decimal places etc.
Let us know if it behaves as intended.
Pete
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
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).
I couldn't get suggestions #1 and #2 to work. What is VBA?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks