![]() |
#5
|
|||
|
|||
![]()
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. |
Tags |
combine data in cells, vba to display a formula. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to match one list with another and return certain values from corresponding cells in excel | Oluagbe1 | Excel | 10 | 02-11-2019 07:00 PM |
![]() |
trevorc | Excel Programming | 4 | 10-11-2018 03:49 PM |
![]() |
Kubi | Excel | 3 | 08-07-2017 11:52 PM |
Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
![]() |
tinfanide | Excel | 4 | 08-30-2014 07:03 AM |