Formating the number in an alpha numeric formula? 1

[AppStaff]

="Enhancement Total Hours= "& SUM(K11:K185)

This is an example of the formula I'm using to label my total for a range of cells.

I can't seem to find a way to format the sum so that it includes a thousands separator. I've tried things like

="Enhancement Total Hours= "& Format(SUM(K11:K185),"#,###")

and other assorted combinations but they all produce an error.

is there a way to do this in the same cell? And whats happening behind the scene that won't let me use a format function? Thanks for any responses.

 

[AnotherHiggins]

You're so close... Try this:
[COLOR=blue white]="Enhancement Total Hours= "& text(SUM(K11:K185),"#,###")[/color]

[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886

 

[AppStaff]

Thanks so much! This was driving me Nutty

A star for your answer.

 

[AnotherHiggins]

Glad to help



[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886