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