="h1+6="&VALUE(H1+6)

--
Don Guillett
SalesAid Software

"pnorgate" wrote in
message ...

For the life of me I don't know how to change a formula in a cell i.e.
=A1 + D4 which will give a final value to show the actual values for A1
& D4 i.e. 2 + 4 = 6 and show this equation in the cell itself. Is this
possible?

It's for a school project for my son who's 10yo.

Can anyone help please?

Cheers from downunder - Melbourne.

Pasha


--
pnorgate
------------------------------------------------------------------------
pnorgate's Profile:
http://www.excelforum.com/member.php...o&userid=37753
View this thread: http://www.excelforum.com/showthread...hreadid=573365