Excel 2010 Commas In Chart with Formula

[endofline]

I've created a formula in excel that I'm using to reference as my horizontal axis labels. The equation is as follows:

="MedCode "&AO4&" $"&ROUND(AT4,0)

Where the ROUND(AT4,0) is a dollar amount that is being rounded to the nearest whole dollar. This is how it looks on the axis:

[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl66, width: 64"]MedCode 282 $4953[/TD]
[/TR]
</tbody>[/TABLE]



Since I'm working with large dollar amounts, I want to be able to have them separated by commas. This way it'll read like this:



[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl66, width: 64"]MedCode 282 $4,953

[/TD]
[/TR]
</tbody>[/TABLE]

How do I make that happen? Thanks!

 

[pgc01]

Hi
Welcome to the board

Try:

="MedCode "&AO4&TEXT(ROUND(AT4,0)," $#,##0")

 

[endofline]

Works perfectly! Thanks for the welcome and the help!

 

[pgc01]

You're welcome.