View Single Post
 
Old 05-31-2023, 12:00 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 345
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

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.
Reply With Quote