Use of parantheses (Layout)

[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

 

[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.

 

[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.

 

[IC]

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.

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

 

[Eric]

Hi,

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

 

[IC]

Hi,

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

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.

 

[Ken Russell]

Format Cells, Custom #,##0;(-#,##0)

Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..