Description: I created a series of formulas to lean how to do this stuff in Libre, since i only know Excel. Pasting a formula as a value with or without formatting adds a ' to the value, breaking it when using SUM, not to mention it should NOT be there. (A1) Remnux , 30 Gig (C1) =FIND(",",A1,1) (D1) =LEN(A1) (E1) =RIGHT(A1, D1-C1) (F1) =TRIM(E1) (G1) =LEFT(F1,3) (H1) =TRIM(G1) Copy the final formula, and paste in as a value, and I get '30 NOT 30. Note, B1 is my hand value of 30, and is not used in my formulas. It does not matter if you choose keep formatting or not. I choose just numbers too, and it did not resolve the issue. In the main spreadsheet: I forced all cells to numbers, which they already were. Did not help. I am running this on a new laptop running Ubuntu 18.04 (all software updated) (Dell XPS 13). Steps to Reproduce: 1. Put in my values and formulas above. 2. Copy the 30 in G1 (which is still a formula) 3. Right click and paste special/paste special/values Actual Results: '30 Expected Results: 30 Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Copied the value of the formula, which was just the value 30. I did this on a series of info, not just the one example I gave you. All failed by adding the ' to the value I copied as unformatted text, and it pasted in just the values, the way copy values should have worked.
Results of functions RIGHT, LEFT, TRIM are text. Copying result and pasting don't convert text to numeric value. Use VALUE before copy, (example in H1) : =VALUE(TRIM(G1))