Formatting when using concatenation.
 

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

Formatting when using concatenation.
 

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

Vaya con Dios,
Chuck, CABGx3


"Softley" wrote in message
...
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