We help IT Professionals succeed at work.

Some questions about using Excel?

nickg5
nickg5 asked
on
Medium Priority
295 Views
Last Modified: 2012-08-13
1. I am trying to put (55.67) in a cell and I'm getting -55.67.
How to use (    and    )   ?

2. How to add a column of numbers?

3. How to add a column of numbers that are in this format?
(55.67)
334.67
123.11
456.70
(12.98)

Comment
Watch Question

Entering a number with parentheses denotes a negative number, hence, the -55.67.
In other words, (x) represents -x.

The second part of your question:
The column of numbers you included contains both positive and negative numbers. Below is the result.

-55.67 or (55.67)
334.67
123.11
456.7
-12.98 or (12.98)
845.83


In order to do this in Excel:
1) Select all cells in column to add.
2) Click the AutoSum button on the Home toolbar or under the Formulas toolbar (Varies depending on Version of Excel)
3) The result is automatically generated in the cell below the cell added up.
CERTIFIED EXPERT

Author

Commented:
I need (55.57) to end up in the cell, exactly as it is entered.
I can not use -55.57

If I can put (55.57) in a cell,
can the program then add these?
(55.57)
312.45
13.45
7890.00
(452.45)
To clarify, you wish to have the number in the cell look like (55.57). You need it to visually appear like this with the parentheses in place. However, you need the value to be +55.57. Is this all correct?
OK, I realized I was over-thinking this one a bit.

I think what your asking is how to represent a negative value of -55.57 in Excel as (55.57).

1) Right click the cell
2) Select Format Cells
3) Under the Number TabCategory: select Number
4) To the right of this under Negative Numbers: select desired formatting of display.
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

you can use a custom format to display numbers with special characters. If you want (55.57) to represent a positive value, then use the custom format

(General)

or, if you only want to show two decimals, regardless of how many are entered, use

(0.00)

It will still be a positive number. In the attached file, please find this custom format in action. Also, in case you want the number in brackets to be regarded as a negative number, I've added a column of numbers with custom format

0.00;(0.00)

Negative values will be displayed with the round brackets.

The format for negative numbers is determined by the operating system regional settings. If you always want to use brackets around negative numbers, you need to change the standard format for negative numbers in the control panel > Regional and Language settings (Windows XP)

cheers, teylyn
Book1.xls
CERTIFIED EXPERT

Author

Commented:
microcosm:
I need the (55.57) to appear as (55.57) BUT, represent a negative number, (not + 55.57) since the bracket represents negative numbers on my tax return. The IRS said it needed to be the same format (columns, etc.) as their form.

Adding points and 2 last questions.

Two last questions, and please note that the new questions eliminate the example above of having to enter a negative number as (xxxx) and having it appearing as (xxxx).          

Can Excel subtract a number in a horizontal cell from another horizontal cell?
Two scenarios:
1. Can the number 44.50 in cell A, be added to the number 33.60 in cell B, to get the number 78.10 in cell C.   How?

2. Can the number 44.50 in cell B, be subtracted from the number 33.60 in cell A,
to get the number -10.90 and have it displayed (appear) as (10.90) and not -10.90
How?

So, I need these two types of calculations:
done across the cells, instead of down the columns.

           cell A       cell B         cell C
line 1   44.50       33.60        Excel to add 44.50 & 33.60 to get 78.10 in cell C

line 2   33.60       44.50        Excel to subtract 44.50 from 33.60 to get (10.90)
                                           in cell C, with the (10.90) being displayed as (10.90)

Thanks.


CERTIFIED EXPERT

Author

Commented:
I used right click on the cells > format > to get the (10.00) on line 1.
I have entered numbers in line two, cell A and B.

How to get the program to subtract B from A, even though B is a larger number?
Untitledhhhhhh.jpg
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

see the attached file.

You can use formulas like

=A1+B1

or

=Sum(A1:B1)

If you want to subtract values, use the - sign. In row 2 of the attached example, on Sheet3:

=A2-B2

The result in cell C is formatted with the custom format

0.00;(0.00)

as described in the previous post.

Does that help?

teylyn



Book1.xlsx
CERTIFIED EXPERT

Author

Commented:
teylyn:
sheet 2 and 3 are empty.
I am not understanding what I see on sheet 1.
-------------------------------------------------------------------------------

I'd like to subtract a number in column B such as 45.00, from a number in column A, such as 10.00.
I'd like the result to be in the format (35.00).

                  A              B             C
line 1      10.00        45.00      (35.00)     is what I need with Excel doing the math.
---------------------------------------------------------------------------
                 A               B             C
line 1      10.00        45.00      -35.00         is not what I need
-------------------------------------------------------------------------------------

I'll look at the other file you provided in comment:
ID:37081984Author:teylynDate:11/04/11 02:48 AM
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Sorry, I accidentally attached a workbook meant for another thread.

Find in the attached file:

data in columns A and B
formula in column C: =A1-B1  (copied down)

C1 is formatted with custom format

0.00;(0.00)

to display negative numbers in brackets.

C2 is formatted to display negative numbers with the defaults of YOUR system for negative numbers. That may be a - sign, like -35.00 , or it may be showing the number in red or it may be showing the number with a leading % sign. There are many different ways to show a negative number. The standards vary from country to country.

As I said above, you can change the way a number is displaying in an area of your spreadsheet (or in the whole of your spreadsheet) by applying the custom format to the cells.

But if you need the brackets as the denominator for negative numbers, the quickest way is to use the computer's system settings.

cheers, teylyn
Book2.xlsx
CERTIFIED EXPERT

Author

Commented:
thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.