Formatting a value in a concatenated cell

[John]

Hopefully i've got the right forum here.

Best explained by example. In B1 i have '2008 Forecast' as a heading. I
show the total for '2008 Forecast' using ="2008 Forecast "&sum(B2:B65536).
This would show '2008 Forecast = 100000000. Problem is i want to show say
100000000 as 100,000,000. Any ideas how i may do this please?

Thanks
John

 

[Mike H]

John,

First I'd use the B1 heading as a reference and then format it like this

=B1&" "&TEXT(SUM(B2:B65536),"000,000")

Mike