Adjust the format of the number ot suite...

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

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

Jim Thomlinson


"SANDIND" wrote:

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