Excel 2007 : Extracting numbers into text fields

I'm on Excel 2010 (don't see that board so i'm posting in 2007).

So I have the following number cells:
A1= 1.555
b1=1.321
c1=1.829

All number formats. And then I limit it to 2 decimal places so it shows
A1= 1.56
b1=1.32
c1=1.83

I want to combine these numbers and create a text field to show in D1=1.56 (1.32,1.83)

I have to do this for about 200 rows. so wondering is there a way to do this without manually typing it?

Originally Posted by pennywaltz

I'm on Excel 2010 (don't see that board so i'm posting in 2007).

So I have the following number cells:
A1= 1.555
b1=1.321
c1=1.829

All number formats. And then I limit it to 2 decimal places so it shows
A1= 1.56
b1=1.32
c1=1.83

I want to combine these numbers and create a text field to show in D1=1.56 (1.32,1.83)

I have to do this for about 200 rows. so wondering is there a way to do this without manually typing it?

Originally Posted by NBVC

Do you mean?

=TEXT(A1,"0.00") & " (TEXT(B1,"0.00")&", "&TEXT(C1,"0.00")&")"

To get close to the format you supplied (not sure if you need it to drop down a line like above or not), you'd need to add the folowing:

=TEXT(A1,"0.00")&CHAR(10)&" ("&(TEXT(B1,"0.00")&", "&TEXT(C1,"0.00")&")")