Show final decimal place digit when it is zero?

I have a feeling that the answer to this question might be embarrassingly simple, but I can't find the answer so here goes...

I would like to generate a result which will be shown to the same number of decimal places as the original figure, even where the final decimal place digit is a zero. For example, in the calculation 87.30 + 0.10 = 87.40 I would like the zeroes at the end of 87.30 and 87.40 to be shown on the worksheet.

I cannot simply format the result cells to display a fixed number of decimal places because the required number of decimal places varies depending on the input number. For example, a starting number of 1.7640 will always require a result to be shown to 4 decimal places, but an input figure of 87.20 will require that the result be shown to 2 decimal places.

I can get the input number to show correctly if I format the cell as Text. However, I have not been able to find a way to show the result to the required number of decimal places when the final decimal place digit is zero. For example, if the contents of cells are as follows;

Cell A1
87.30

Cell A2
0.10

Cell A3
=A1+A2

This would yield the result 87.4 in Cell A3, but I would like it to appear as 87.40.

Can anyone tell me how I can achieve this?

Thanks.

Originally Posted by Andy Pope

A3: =text(a1+a2,"0."&rept("0",len(a1)-find(".",a1)))

Great - that solves my problem.

Thanks for your help.