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]

Valmir take care error value in this formula return text ("") not number.
This result can cause error if you will use this result in another calculation.
This result is not same as zero.