Adding two numbers as decimal

[valmir]

Hello everyone! I wonder if there is a way in excel to add two numbers and have the result as a decimal number in which the first number will be the whole number part and the second number will be the decimal number part. Example: I have "2" in column A and "5" in column B, the result in column C will be "2,5". I tried to do this with this formula
=TEXTJOIN(","; TRUE; A1:B1)
But the result does not come as number, but rather as text and behaves as text which does not serve my purpose.
Thanks

 

[EXCEL MAX]

Copy formula from my post 7 to new sheet. Check on default cell format.

 

[valmir]

=IFERROR(VALUE(A1&B1)*1/VALUE("1"&REPT("0";LEN(B1)));"")

It works! Thank you so much for your help and patience and everyone else who cared to help! ? ??

 

[EXCEL MAX]

I'm glad that you found this as solution, but now I see Arthurbr's formula also correct and much more simple.

 

[arthurbr]

I'm glad that you found this as solution, but now I see Arthurbr's formula also correct and much more simple.

Thank you. OP's have the tendency to look at the last answers not the first ones. It's been frustrating me for years on forums...

 

[arthurbr]

Wow! I never thought that this would be so hard to achieve. I tried all those formulas and none of them is working. For example when adding "0" and "3" I was supposed to get 0,3 but I am getting 0 as the result

Are you sure my suggestion does not work?? It does for me and does not need more than one function

 

[Rick Rothstein]

I don't think such a complicated formula is needed. This worked for me...

=0+TEXT(A1&"."&B1,"General")

Note: My decimal point is a dot... yours seems to be a comma so you might have to use that instead.

 

[valmir]

Are you sure my suggestion does not work?? It does for me and does not need more than one function

I'm sorry Sir, your suggestion works perfectly. It is my fault. I am not so knowledgeable in excel so at the time when I was trying your formula I had the wrong formatting. It wasn't until someone told me about the formatting that I got it working. Again I am sorry but as a "not-so-regular" excel user sometimes we tend to neglect or forget about basic things. Thanks again for your help

 

[Rick Rothstein]

Actually, the formula can even be simpler...

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

Note: Again, my decimal point is a dot... yours seems to be a comma so you might have to use that instead.

 

[EXCEL MAX]

Also nice formula Mr Rothstein, especially part ->converting text format to number by adding zero.
Is it formatting necessary?
I found this formula gives well result.
=IFERROR(0+(A1&"."&B1),"").
Ha, Ha. We still thinking.

 

[valmir]

Also nice formula Mr Rothstein, especially part ->converting text format to number by adding zero.
Is it formatting necessary?
I found this formula gives well result.
=IFERROR(0+(A1&"."&B1),"").
Ha, Ha. We still thinking.

I actually tried Mr. Rothstein's formula but it is not working for me. This one that your just posted works too.