![]() |
|
#1
|
|||
|
|||
![]()
To follow up on this, as it may come in handy for someone else...
I was using =CONCATENATE("="&F7&"+"&D7) to get started, and that works when the running total in F7 is just a number (the quantity used to date.) But when that cell is eventually replaced with the running "adding machine tape" that she wanted (=2+0+3+2), I ended up using =CONCATENATE(FORMULATEXT(F7)&"+"&D7 Seems simple, but it took me a while to sort out what would work. I do that in a helper column, paste values over the F row, then use a little helper macro to refresh all those cells so it goes back to a working formula again. |
![]() |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
kungfauxn00b | Word Tables | 3 | 04-05-2011 04:54 AM |