Hello, allot of times i copy and paste from web doc to excell (eg with bank statements) the column with the money is not recognized by excell as a number. at the bottom right of page where it would usually show toatal of cells , it just says count. so you can't use the figures. really anoying, i tried formating the cells in different ways but no good.
I will suggest you to copy and paste the characters and the values seperately. When you are pasting the values, right click and choose paste special characters from the list and then choose either currency or number, this might solve your problem