Thread: Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Naji[_2_] Naji[_2_] is offline
external usenet poster
  
Posts: 9
Default Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
Is this even possible?

I have the following:

A1 =A2 (Shows result of 10)
A2 10
A3
A4 =A5 (Shows Result of 2)
A5 2

A7 =10+2 (Shows result of 27)

Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!
Reply With QuoteReply With Quote