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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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,172,173
Messages
5,879,463
Members
433,434
Latest member
skk0048

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