How do you if youre referencing a cell in the middle of txt set the amount
of decimal places it uses.

Example

a b
1 average 41.333333 days 41.3

Cell A1 has the function: =€�average €�&B1&€� days€�
B1 actual value is 41.333333 with a format of 1dp.

I want to get the outcome

a b
1 average 41.3 days 41.3

Is there a way to do this.

Try

="Average "&TEXT(B1,"0.00")&" days"

Mike

"laandmc" wrote:

How do you if youre referencing a cell in the middle of txt set the amount
of decimal places it uses.

Example

a b
1 average 41.333333 days 41.3

Cell A1 has the function: =€�average €�&B1&€� days€�
B1 actual value is 41.333333 with a format of 1dp.

I want to get the outcome

a b
1 average 41.3 days 41.3

Is there a way to do this.

="average " & TEXT(B1,"#,##0.0") & " days"


Gord Dibben MS Excel MVP


On Wed, 24 Sep 2008 03:21:01 -0700, laandmc
wrote:

How do you if you’re referencing a cell in the middle of txt set the amount
of decimal places it uses.

Example

a b
1 average 41.333333 days 41.3

Cell A1 has the function: =”average ”&B1&” days”
B1 actual value is 41.333333 with a format of 1dp.

I want to get the outcome

a b
1 average 41.3 days 41.3

Is there a way to do this.