On Wed, 19 Aug 2009 13:42:10 -0700, 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

Example

A1: Text
A2: 123,456,789.00

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

--ron