,000 Separator after Concatenate

[SANDIND]

Hi,

If i concatenate two cells or more than that , and I could see that after
concatenation I loose Thousand separator from numeric values, please advise
how can we have '000 separator to numeric values even after they are
concatenated.

SS

 

[Jim Thomlinson]

Adjust the format of the number ot suite...

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

Where A1 is Text and B1 is a number...

 

[Ron Rosenfeld]

Hi,

If i concatenate two cells or more than that , and I could see that after
concatenation I loose Thousand separator from numeric values, please advise
how can we have '000 separator to numeric values even after they are
concatenated.

SS

Example

A1: Text
A2: 123,456,789.00

=a1 & " " & text(a2,"#,##0.00")

--ron