Format Part of a Cell

[eforti]

Hello All,

I have the following formula in my cell:

="Monthly $"&B12&"
"&
"Annually $"&C12

For display purposes lets say it shows the below:

Monthly $100.23
Annually $1002

This shows a monthly expense and annual expense. The two numerical values do not have commas and are inconsistent with decimal places. How would I modify this so that I get zero decimal places and the comma to seperate 1000's?

I'd like the output to be something like this:

Monthly $100
Annually $1,002

Any help is appreciated

 

[NBVC]

="Monthly "&TEXT(B12,"$#,###")&CHAR(10)&"Annually "&TEXT(C12,"$#,###")

Formatted to Wrap Text (Alignment tab).

 

[DominicB]

Good evening eforti

Try this :

="Monthly $" & TEXT(B12,"#,000") & " " & "Annually $"& TEXT(C12,"#,###")

HTH

DominicB

 

[eforti]

That worked perfectly DominicB! Thank you!