View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Formatting a value in a concatenated cell

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