| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
number formats after concatenate
Hi Duke,
Thanks a bunch. Mary "Duke Carey" wrote: try =text(A1,"#,##0")&" - "&text(B1,"#,##0") "Mary" wrote: I have two number columns with #,### formats, I need to concatenate the columns and display as a range without loosing the format eg col A col B col C ( Range) 1,000 1,500 1,000 - 1,500 when I use the concatenate function, I lose the comma format of the numbers. so, it comes as 1000 - 1500 instead of 1,000-1,500. Can someone help me???? |
|
#2
|
|||
|
|||
|
try
=text(A1,"#,##0")&" - "&text(B1,"#,##0") "Mary" wrote: I have two number columns with #,### formats, I need to concatenate the columns and display as a range without loosing the format eg col A col B col C ( Range) 1,000 1,500 1,000 - 1,500 when I use the concatenate function, I lose the comma format of the numbers. so, it comes as 1000 - 1500 instead of 1,000-1,500. Can someone help me???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combobox Number Formats | Excel Worksheet Functions | |||
| How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
| concatenate number format issue | Excel Worksheet Functions | |||
| number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
