Formatting when using concatenation.

S

Softley

Is there a way to format a component of a concatenated string. i.e. make a
value read as currency, or make it bolded?--
DS
 
C

CLR

A1=123
B1=45
C1= ="$"&(A1&B1)/100 returns display of $123.45 as TEXT

Vaya con Dios,
Chuck, CABGx3
 
Top