Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2022, 02:17 PM
kilroyscarnival kilroyscarnival is offline Converting formulas from cell references to numbers Windows 10 Converting formulas from cell references to numbers Office 2021
Expert
Converting formulas from cell references to numbers
 
Join Date: May 2019
Posts: 363
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

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



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 formulas from cell references to numbers 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
Converting formulas from cell references to numbers Cell formulas & formatting kungfauxn00b Word Tables 3 04-05-2011 04:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft