|
|
#2
07-19-2022, 02:11 PM
|
|||
|
|||
Lame as this is, it sort of works.
In a column to the right, concatenate: =CONCATENATE("="&P15&"+"&Q15&"+"&R15) Take that column, and paste As Values to the right of it. It will display as =1+2+3 reading as text, rather than returning the total. Then highlight that column and run a macro replacing one of the formula's components with itself. I chose replace = with =, since there's an equals sign in every formula. It does change to displaying 6, and when you click in, it shows =1+2+3 in the formula bar. Yes, it's a nuts thing to need to do. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA or Formulas to parse out numbers based on criteria | durwood | Excel Programming | 2 | 09-17-2019 06:59 PM |
| Rounding numbers in formulas | Lamont | Excel | 3 | 01-09-2019 08:19 AM |
 Converting xls(x) with formulas to pdf
|
rheaney | Excel | 2 | 11-22-2016 03:30 PM |
| Fields and References Don't Show as Numbers | peytontodd | Word | 2 | 05-31-2014 07:05 PM |
|
Cell formulas & formatting
|
kungfauxn00b | Word Tables | 3 | 04-05-2011 04:54 AM |
Windows 10 
Office 2021
Threaded Mode