Format Part of a Cell

eforti

Board Regular
Joined
Aug 15, 2005
Messages
220
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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
="Monthly "&TEXT(B12,"$#,###")&CHAR(10)&"Annually "&TEXT(C12,"$#,###")

Formatted to Wrap Text (Alignment tab).
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening eforti

Try this :

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

HTH

DominicB
 

Forum statistics

Threads
1,136,354
Messages
5,675,301
Members
419,560
Latest member
g3org

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top