ExcelBanter - number formats after concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - number formats after concatenate (https://www.excelbanter.com/excel-worksheet-functions/50398-re-number-formats-after-concatenate.html)

Mary

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????

Duke Carey

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????

All times are GMT +1. The time now is 08:20 AM.