Use of parantheses (Layout)

E

Eric

Hi,

I have a column of number that I would like to add
parantheses, the problem is that when I change the format
the numbers the negative numbers appear as -(3) instead
of (-3). Is there a way to have the negative sign between
the parantheses? Thanks,

Eric
 
B

BenjieLop

This might be your solution. In Cell B1, enter (and copy down)

="("&A1&")" where A1 contains the number that you want to be i
parentheses.
 
E

Eric

Hi,

Do you know how to show only 2 digits after the period?
When I use the syntax mentionned below it shows me all
the digits after the period, but I would like to have
only 2 digits...thanks for the help.
 
I

IC

Eric said:
Hi,

Do you know how to show only 2 digits after the period?
When I use the syntax mentionned below it shows me all
the digits after the period, but I would like to have
only 2 digits...thanks for the help.
Click to expand...

="("&FIXED(A1,2)&")"
 
E

Eric

Hi,

Is this syntax available in the help? if not where can we
find that kind of stuff?
 
I

IC

Eric said:
Hi,

Is this syntax available in the help? if not where can we
find that kind of stuff?
Click to expand...

Yes. Type rounding into the answer wizard and one of the options is FIXED
worksheet function. Just a ponit, though. The addition of parentheses in
this manner has changed th cell data from a number to text which is why
Fixed needs to be used instead of Round. If you still want your data as a
number (for calculations etc), the best option is to create a custom cell
format.

Go to Format-Cells-Number-Custom and type 0.00 ;(-0.00) in the Type box.
This will align your positive and negative numbers by adding a space after
the positives to offset the parenthesis aflet the negatives.
 
Top