,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Padding and Concatenate 2
Joining the contents of several cells into a single one 6
how to generate a date in barcodefont? 1
Concatenate not working 2
Which function/s should be used on a multi conditional formula? 4
Concatenate Multiple Cells into A Single Cell 2
Concatenate Problem 3
Concatenate Data inn different columns 4

Back
Top