View Single Post
Old 07-19-2022, 02:11 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Competent Performer
Join Date: May 2019
Posts: 237
kilroyscarnival is on a distinguished road

Lame as this is, it sort of works.

In a column to the right, concatenate:

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