Hi,

To keep a record of my calculations I would like to be able to display all the components of a formula in the cell next to the result.

For example:
With A1 = 1 & A2 = 2
& formula in cell A3= "=A1+A2"
Excel displays the result of the formula in cell A3, 3 in this case.

I would like a formula that I can put in cell B3 that displays "=1+2"
I know that I can manually create a formula to do this =A1&"+"A2 but want one formula that will automatically change when the formula in Cell A3 changes.

I have a user defined function that will display the formula:
Function CELLFORMULA(cell)
CELLFORMULA = cell(1).Formula
End Function

But this displays "=A1+A2", I want the cell references A1 and A2 to be substituted with the values of cell A1 and A2, better still if the numbers are displayed in the format that is currently being used on the cells that the numbers come from.

Any assistance will be appreciated.

Regards.

Sean Bartleet