I have a problem with an excel sheet where some of the numbers look like a number with no decimals and with 1000 separator. Excel doesn't read this as number and it is impossible to change format. I have changed format to number, and it says that it's a number, but even if I add decimals or remove 1000 separator, nothing happens to the number in the cell. Down in the corner of the document, it only counts number of cells, but not the value in the cells. This applies to a rather large amount of data, so it is out of the question to type the cells in a neighbouring cell.... I have also tried copy number (123) and copy format from cells that has the correct format.