| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate with Formatting
I'm using concatenate to piece together several cells in Excel 2007. One of
the cells is in a number format with a comma (1,869). However when I concatenate the cell the formatting doesn't show up. Does anyone know how to use concatenate and keep the number format? Concatenated version Total Fall On Campus Sections=1869 Sam |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate with Formatting
="Some Text " & text(A1, "#,##0")
where 1869 is in cell a1 -- HTH... Jim Thomlinson "Sam" wrote: I'm using concatenate to piece together several cells in Excel 2007. One of the cells is in a number format with a comma (1,869). However when I concatenate the cell the formatting doesn't show up. Does anyone know how to use concatenate and keep the number format? Concatenated version Total Fall On Campus Sections=1869 Sam |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate with Formatting
Thanks!
"Jim Thomlinson" wrote: ="Some Text " & text(A1, "#,##0") where 1869 is in cell a1 -- HTH... Jim Thomlinson "Sam" wrote: I'm using concatenate to piece together several cells in Excel 2007. One of the cells is in a number format with a comma (1,869). However when I concatenate the cell the formatting doesn't show up. Does anyone know how to use concatenate and keep the number format? Concatenated version Total Fall On Campus Sections=1869 Sam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate whilst keeping formatting | Excel Discussion (Misc queries) | |||
| concatenate & conditional formatting in one | Excel Discussion (Misc queries) | |||
| CONCATENATE Date formatting | Excel Worksheet Functions | |||
| Concatenate and Conditional Formatting | Excel Discussion (Misc queries) | |||
| How can I concatenate a number and preserve the formatting? | Excel Worksheet Functions | |||
Hybrid Mode
