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.