View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laandmc laandmc is offline
external usenet poster
 
Posts: 23
Default 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.