changing format code?? please help!!!
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.
|