Hi, I just copied a simple 1 column, 12 rows piece of table containing only numbers and none of the above, nor what´s in your comments like using TRIM or VALUE RIGHT worked. If I use =VALUE(RIGHT(A1,3)) it said "We find a problem with this formula, if i only put (A1) it will work but it will only show the last digit. After the instruction =VALUE(TRIM(A1)) it shows "#VALUE!" but no number. All of the above resulted in similar issues, what´s wrong with this? I can´t believe it´s so difficult to just copy and paste some numbers from a website and try to work on them with Excel. I´m using Excel professional 2013. Any help welcome, thanks!