Formatting when using concatenation.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
A1=123
B1=45
C1= ="$"&(A1&B1)/100 returns display of $123.45 as TEXT

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keep source formatting when concatenating 1
Color within Concatenate 2
Concatenating Currency and Percent 5
Concantenate which keeps bold of some parts. 5
Concatenate whilst keeping formatting 1
Change font formatting in a concatenated string 1
How to concatonate two words with first word in BOLD format? 3
Bold a portion of concatenated string 1

Back
Top