Hi bernard

See the response from RagDyer to my question - Rag understood my question (I
did not mean display, I meant more "see values in cell")
Rag's response was exactly what I was looking for, it's great to see there
are these solutions!

thanks all the same for responing to me!

"Bernard Liengme" wrote:

I cannot see how the result of the formula =H11+G20 can be made to DISPLAY
=700+300. But it this is just for reconciliation work and you have Excel
2003 (maybe also 2002 - I forget), use View | Toolbars and select Formula
Auditing. The last tool on this is Formula Evaluation. With your cell
selected you can watch the evolution:
=H11+G100 become
=700 + G100 then
=700 + 300 and finally
=1000
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"LinLin" wrote in message
...
Hi Everyone

Sometimes it is useful for me to show that a cell contains a string of
numbers which make up a total.

For instance, I would show in a Cell that the total you see ($1000) is
made
up of $700 + $300

Sometimes, those individual amounts come from different sources / links.

So, (as an example) H11 ($700) plus G20 ($300) = $1000

In the cell it shows = H11 + G20

Is there any function which will transpose those cell references to the
amounts they represent WITHOUT summing them in the cell?

IE I would like to get = H11 + G20 to show = 700 + 300
NOT =1000

Does anyone have any ideas?
This kind of thing is very useful for reconciliations etc.

thanks!