Formatted cells used in a Concatenate formula

Hi,

If you're concatenating cells, one or more of which are numbers then the result is going to be a string and hence not capable of being given a numeric separator. You'll need to make sure that the separator is included as you concatenate the two cells. e.g. assuming A1 contains the number

Formula:

=TEXT(A1,"0,0")&B1