View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pnorgate pnorgate is offline
external usenet poster
 
Posts: 1
Default Show values in formula instead of cell reference


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