When you say custom format "Total="0, is this an option in excel the
custom format.

David Biddulph wrote:

But if you want C1 still to be a number (rather than a text field) for
further calculations, use C1 =A1+B1 and custom format as
"Total="0
--
David Biddulph

"Zone" wrote in message
ups.com...
Put this formula into C1:
="Total="&SUM(A1:B1)

Dave wrote:
Is there way with a calculation to display the text in the same cell.

Say:

a1=1 b1=2 c1=3(Total)

In c1 say, could you get the cell to display: Total=3