Hi!, iīm using Excel 2013 on win 8.1, I pasted a table from a website into Excel, the numbers in it are formated in text since they are allingned to the left and no formula like sum work on them, I tried every posible method available to convert those cells into numbers, They donīt have any exclamation mark next to them so that I canīt chose to convert directly, I tried the special paste method by creating and copying a "1" cell, and then multiplying all cells to that number and nothing happens, the numbers keep being shown to the left and no formula work, I tried converting the cells into an Excel table but it doesnīt work, nothing happens. Some cells have a letter next to its number like 5p which I thought could be the cause but if I try selecting only the cells with numbers without letters nothing Works either. I donīt know what to do now, this should be a very easy thing to do but I hope not to have to enter all numbers manually in new cells, if anyone knows how to convert these apparently text cells to general or number cells please give me a clue, thanx!!