Hi RD

Err, I've tried it out and it is extremely helpful BUT is there anyway to
then return the number value of the cell ? In the end, I still need to know
that the formula cell value is 1000.
I guess I can have the Ampersand forumla Cell as well as the normal formula
cell, but if you have other suggestions, that would be great.
(I know, I'd like my cake and eat it too!)

"RagDyer" wrote:

Try this:

="="&H11&"+"&G20

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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!