| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting a value in a concatenated cell
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 "John" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different font characteristics in concatenated cell | Excel Worksheet Functions | |||
| Number Formatting in a concatenated cell | Excel Worksheet Functions | |||
| Formatting Concatenated Cells | Excel Discussion (Misc queries) | |||
| Change font formatting in a concatenated string | Excel Discussion (Misc queries) | |||
| sorting a concatenated cell | Excel Discussion (Misc queries) | |||
Linear Mode
