View Single Post
  #4   Report Post  
Josh
 
Posts: n/a
Default

try the text function:

=3DH2&" "&I2&" Units"&" (Ave "&TEXT(K2,"=A30.0")&")"

You can adjust the decimal point and format of your number (i.e. 0.0,
0=2E00, 0,000.00, etc)