,000 Separator after Concatenate

  • Thread starter Thread starter SANDIND
  • Start date Start date
S

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
 
Adjust the format of the number ot suite...

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

Where A1 is Text and B1 is a number...
 
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
Click to expand...

Example

A1: Text
A2: 123,456,789.00

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

--ron
 
Back
Top