number formats after concatenate

[Guest]

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

 

[Bryan Hessey]

=TEXT(A1,"#,###")&" - "&TEXT(B1,"#,###")

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