View Single Post
Old 07-19-2022, 01:50 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Competent Performer
Join Date: May 2019
Posts: 237
kilroyscarnival is on a distinguished road
Default Converting formulas from cell references to numbers

Is it possible in Excel to render a cell that shows, instead of cell references, the values within those cells? Like instead of the formula being =Q6+R6+S6+T6+U6, I could get a cell containing the contents, but within a formula (=5+4+0+2+10)?

A coworker suddenly wants every sheet to show a TYPED IN formula instead of the values, which I had calculated with an off-print-area helper column that summed the current and past to-date quantities. Copy/paste values, simple. She wants to see all the individual numbers, and it will take forever to update multiple sheets that way. I was just trying to figure out a workaround.
Reply With Quote