Thread: Excel help
View Single Post
  #2  
Old 18th October 2016, 09:18 PM
walkermac walkermac is offline
Member
  
Join Date: Nov 2013
Posts: 599
Default
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)),"")
Reply With Quote