Display text numbers (custom format)

[3G]

Ok, now that I have my charting issue resolved, I need to add some data labels. In a cell placed directly above the stacked column I have the following:


="Current Total: "&(ROUND(('(t)Hours By Role'!E71),0))


The number displays as 34345, when, I need it as 34,345. How can I format this cell so the text looks as it does, but, the number has the "," for the 1000 separator?

 

[Luke M]

You can use the TEXT function to set formatting on values, like so:


="Current Total: "&TEXT(ROUND('(t)Hours By Role'!E71,0),"#,###")


actually, if you're going to use the TEXT function, you could skip the ROUND part:

="Current Total: "&TEXT('(t)Hours By Role'!E71,"#,###")


since that formatting will automatically cause the value to be rounded to nearest integer.