Concatenate, formatting numbers within

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.
 
P

Peo Sjoblom

You can use TEXT function,

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

as an example for currency format
 
Top