How to add dollar signs and commas to the CONCATENATE formula

Cicely2011

New Member
Joined
May 6, 2017
Messages
1
I am using the following formulas, but I cannot figure out how to get my result to include a dollar sign and commas to appear as currency. Can someone show me where I need to put edits?

=CONCATENATE("You want to make $",ROUND($D$7/($D$8/12),0), " per year?")

Currently producing: You want to make $500000 per year?

=CONCATENATE("You need to make ",ROUND(D7/D8,0)," per month")

Currently producing: You need to make 41667 per month.

=CONCATENATE("That's about ",ROUND(D7/D8/30,0)," per day")

Currently producing: That's about 1389 per day.

I need them to say You want to make $500,000 per year? You need to make $41,667 per month. That's about $1,389 per day.
 

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,485
Try

=CONCATENATE("You need to make ",TEXT(ROUND(D7/D8,0),"$#,##0")," per month")
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Looks like you just want to combine all of those?
If so, then maybe this?
="You want to make $"&ROUND($D$7/($D$8/12),0)& " per year?"&" You need to make "&ROUND(D7/D8,0)&" per month"&" That's about "&ROUND(D7/D8/30,0)&" per day")
 

Forum statistics

Threads
1,085,995
Messages
5,387,148
Members
402,045
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top