ADD two cell's and add comma!!!!

[buddy1000]

I have in cell A1 5000
and in cell B1 50

the original figure is 5000,50

Does anyone know a formula in cell C1 that will add cell A1+cell B1 and place the comma as indicated.

I tried Concatenate but it gives 500050 and disregards the comma.
Any ideas?

 

[schielrn]

Can you use:

=A1&","&B1

Or this works for me with concatenate:

=CONCATENATE(A1,",",B1)

Hope that helps.

 

[VoG]

If you want the result to behave as a number try

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

 

[DonkeyOte]

and your santity buddy, concatenate would work but with

=CONCATENATE(A1,",",A2)

or

=CONCATENATE(A1,CHAR(34),A2)

I prefer the latter as I find it easier to make sense of at a glance.

 

[buddy1000]

Thank you...

All solutions work
cheers