Oh, you want to actually see the individual figures?
In your destination cell try:
=CONCATENATE("="&A23&"+"&A24&"+"&A25)
That cell will now display "=35+100+-60" but it's merely a text string.
If you wanted to make it a calculable number again, copy, paste values, and then you'll need to do something to refresh that cell for it to convert back to a number where it will display the "75" but in the formula bar you will see the =35+100+-60. You can click inside the formula then out and that should refresh it. My cheat involves having a macro button that runs a macro simply replacing every digit from 0 through 9 with itself, thereby refreshing all numbers.
|