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

 

[arthurbr]

Perhaps

=A1+B1/10^(LEN(B1))

 

[arunsjain]

Try this

=TEXTJOIN(","; TRUE; A1:B1)*1

or

= TEXT(TEXTJOIN(","; TRUE; A1:B1), "0.00")

 

[EXCEL MAX]

This works for me...
=VALUE(A1&B1)*1/VALUE("1"&REPT("0";LEN(B1)))

 

[valmir]

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

 

[RoryA]

Do you have your result cell formatted to show decimals?

 

[EXCEL MAX]

Correction...
=IFERROR(VALUE(A1&B1)*1/VALUE("1"&REPT("0";LEN(B1)));"")
As Rory say format cell decimal places.

 

[valmir]

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

Yes sir, this one works. Just one problem. When adding for example 13 and 1, I am getting 13 only. Could that be a formatting issue? I have formatted as a number with one decimal place. Can you test this specific example to see if you will get "13,1", please?

 

[EXCEL MAX]

Try to increase decimal places in the cell with this formula.

 

[valmir]

Try to increase decimal

Increasing the decimal places gives me "13,01" instead of "13,1". I wonder if there is a custom format to get it right. And increasing the decimal places messes up with the sorting!