Help with formula to retain brackets in results

[AlisonB]

Hi,

Can someone give me formula that shows brackets in the result? I have
read other posts but they don't do what I want.

I am using Excel 2002 and WinXP.

I have two workbooks – one is a "master" workbook that contains data
and charts based on that data. The second is a csv file that
contains data exported from another software package. The idea is
that when I receive a new csv file, the data automatically updates the
data and charts in the "master" workbook.

My problem is with the "master" workbook.

Here is my example from the "master" workbook:

A1 shows 77.92 (referenced to the csv file)
B1 shows 3302 (referenced to the csv file)
C1 shows (3302) (referenced to B1 - I got brackets to show by a custom
cell format)

A1 and C1 are the two figures I want to eventually use on a chart, one
above the other. I know Alt + ENTER inserts a hard return to get on
figure above the other, so I can get 77.92 3302 without any problem.

My problem is that when I try to concatenate A1 and C1 into D1 I lose
the brackets and get 77.92 3302 when I want 77.92 (3302).

So I need D1 to show 77.92 (3302) (I am using Rob Bovey's great free
add-in Chartlabeler).

Can someone help me keep the brackets?

You have never let me down before so I am sure someone will come up
trumps!

Thanks

Alison

 

[J.E. McGimpsey]

One way:

D1: =A1 & CHAR(13) & TEXT(C1, "0;(0)")

 

[AlisonB]

Sorry, but I can't get this to work – the brackets still don't show.
Any other suggestions?

Kind regards,

Alison

 

[J.E. McGimpsey]

My misunderstanding - I was thinking that your value in C1 was
negative. Try:

D1: =A1 & CHAR(13) & TEXT(C1, "(0)")

 

[Peo Sjoblom]

Why is 3302 in a bracket? The whole point of using a bracket
is to show a negative number and if 3302 is indeed -3302 it will show
with a bracket. Otherwise you can use

=A1 & CHAR(13) & TEXT(C1, "(GENERAL)")

turn on word wrap

 

[AlisonB]

Brilliant! - I now have my two figures one above the other on my chart
- and the brackets are still there. Once again Google Groups comes to
my rescue!

Thank you very much.

Alison