display calculation steps - not final answer

[skwiff]

I have a spreadsheet which adds up the numbers in a column.

I would like excel to show the steps of the calculation, eg, 1+2+3.
Rather than the final answer, 6, or the formula: A1+A2+A3.

Is this possible?

 

[David Biddulph]

1+2+3 is a text string which you can insert into a cell if you wish to do
so.
You could also use the formula =A1&"+"&A2&"+"&A3

 

[skwiff]

Thanks - second option is perfect.

1+2+3 is a text string which you can insert into a cell if you wish to do
so.
You could also use the formula =A1&"+"&A2&"+"&A3
--
David Biddulph




.