Concatenate, formatting numbers within

  • Thread starter Thread starter ofcoursejohns
  • Start date Start date
O

ofcoursejohns

Anyone know how to format a number, (resulting from cell
reference) that appears in a Concatenate string of both
text and explicit cell references.
 
You can use TEXT function,

=A2&B2&TEXT(C2,"$#,##0.00")

as an example for currency format
 
Back
Top