I have a column full of numbers, but they aren't stored as numbers.
For most of them, Excel automatically offers to convert them to numbers (I have the green error indicator in the upper left hand corner of the cells). For a few, though, it doesn't and I don't see how they differ from the rest. Normal formatting (Home -> Number) doesn't change anything.
I tried using the function
value(), doesn't work. I also tried to PasteSpecial the formats of another cell onto those that are giving me trouble. And I tried to multiply all of the cells with 1, but again the troublesome cells remain unchanged. What can I do?
I imagine it'll difficult to help me without the data, so here's the link to the sheet
edit: As Tom Brunberg pointed out, there's a new line in some of the cells that causes the problems. I removed them via VBA:
Workbooks("Workbook name").Sheets("Sheet name").Range("M1:P70").Replace Chr(10), "", xlPart