ExcelBanter - ,000 Separator after Concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ,000 Separator after Concatenate (https://www.excelbanter.com/excel-discussion-misc-queries/240181-000-separator-after-concatenate.html)

SANDIND[_2_]

,000 Separator after Concatenate

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

,000 Separator after Concatenate

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

Ron Rosenfeld

,000 Separator after Concatenate

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

All times are GMT +1. The time now is 04:51 PM.