Paste as values in Sheets
Copy formula results and paste as values.
When using Ctrl+Shift+V it currently pastes as plain text.
4
votes
-
techguy
commented
more to this point Sheets needs a "paste special" function like every other spreadsheet app so that we can paste "values, formatting, conditional formatting, formulas, data validation"