18th October 2016, 08:18 PM
|
Member
|
|
Join Date: Nov 2013
Posts: 605
|
|
The data is pasted as text, instead of a number. You'll have to convert it before you can perform arithmetic operations.
If the data you want is in column K you could, for example, post this formula in cell Q1 and then fill it down the page:
Code:
=IFERROR(VALUE(RIGHT(K1,LEN(K1)-1)),"")
|